|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
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 |
|
#2
|
||||
|
||||
|
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 |
|
#3
|
|||
|
|||
|
thanks matey!!!
New it would b something really easy. tried everything other than that, lol. thanks again!! |
![]() |
| Viewing: ASP Free Forums > Other > Programming Help > Usin the "If" expression within excel??? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|