Programming Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsOtherProgramming Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old July 4th, 2007, 09:20 AM
garymorgan garymorgan is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Jul 2004
Posts: 38 garymorgan User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 6 h 20 m 29 sec
Reputation Power: 5
Usin the "If" expression within excel???

Hi people

i have now solved my last problem, so now i move to my nxt one, lol.

I know its not MS Access related but wasnt sure where to turn after going through all the help stuff on MS site.

Right its pretty simple really and i will prob be kicking myself once i know how to do so.

Right this is the prob.

I have 2 cells J11 & K19

I want to use an expression so that in another cell it will display either J11 or K19 depending on their values.


basically if "K19" to be displayed if its greater than "J11".

i hav got this code so far:

=if(J11<=k19, value_if_true,value_if_false)

So :
if its true i want it show the value in "k19"
If False to show "J11"

what code do i use in the last bit of the equation??

anything i enter in there in shown in the cell

ie
if i swaped value_if_true with =k19

its actually shows =k19 as a value and not the contense of the cell.

Please Help dudes!!!
Thanks
gary

Reply With Quote
  #2  
Old July 4th, 2007, 10:01 AM
mehere's Avatar
mehere mehere is offline
Senior Sarcasm Wizardess
Click here for more information.
 
Join Date: Feb 2005
Location: Dreamland
Posts: 12,789 mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)  Folding Points: 10976 Folding Title: Novice Folder
Time spent in forums: 4 Months 3 Weeks 6 Days 22 h 25 m 4 sec
Reputation Power: 1567
just list the cell name without the equal sign
Code:
=IF(J11<=k19, k19, j11)
__________________
Come JOIN the party!!!

Quote of the Month:
Sacrifice (Temple): All we ask here is that you give us your heart.

Questions to Ponder:
If the #2 pencil is the most popular, why is it still #2?

iif([sarcasm]=true,iif([you have to ask]=true,"didn't work","ha ha ha"),"not sarcasm")
copyright© 2008 sbenj69

Reply With Quote
  #3  
Old July 4th, 2007, 11:18 AM
garymorgan garymorgan is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Jul 2004
Posts: 38 garymorgan User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 6 h 20 m 29 sec
Reputation Power: 5
thanks matey!!!

New it would b something really easy. tried everything other than that, lol.

thanks again!!

Reply With Quote
Reply

Viewing: ASP Free ForumsOtherProgramming Help > Usin the "If" expression within excel???


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway