Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
why If, THEN does not work
Hello:
I'm trying to get a very simple nested IF, THEN statement to work. But, instead of returning a value, it returns "FALSE". I really don't get it. Below is my formula. Please help!!! =IF($K2="HW","70", IF($K2="SW","75", IF($K2="A","01", IF($K2="LI", "20", IF($K2="F", "60"))))) childofthe1980s |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
why If, THEN does not work
<IF($K2="F", "60")))))
And what if $K2 not equals "F"? Your formula is not complete -- Kind regards, Niek Otten "childothe1980s" wrote in message ... Hello: I'm trying to get a very simple nested IF, THEN statement to work. But, instead of returning a value, it returns "FALSE". I really don't get it. Below is my formula. Please help!!! =IF($K2="HW","70", IF($K2="SW","75", IF($K2="A","01", IF($K2="LI", "20", IF($K2="F", "60"))))) childofthe1980s |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
why If, THEN does not work
works for me, what are you finding it does for you?? -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=519029 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
why If, THEN does not work
=IF($K2="HW","70", IF($K2="SW","75", IF($K2="A","01", IF($K2="LI", "20",IF($K2="F", "60",""))))) you were missing the last 2 quotes at the end of the formula -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=519029 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
why If, THEN does not work
I really don't know what you mean. Could you please explain?
childofthe1980s "Niek Otten" wrote: <IF($K2="F", "60"))))) And what if $K2 not equals "F"? Your formula is not complete -- Kind regards, Niek Otten "childothe1980s" wrote in message ... Hello: I'm trying to get a very simple nested IF, THEN statement to work. But, instead of returning a value, it returns "FALSE". I really don't get it. Below is my formula. Please help!!! =IF($K2="HW","70", IF($K2="SW","75", IF($K2="A","01", IF($K2="LI", "20", IF($K2="F", "60"))))) childofthe1980s |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
why If, THEN does not work
=IF($K2="HW","70", IF($K2="SW","75", IF($K2="A","01", IF($K2="LI", "20",
IF($K2="F", "60","you need to do something here when all else fails))))) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "childothe1980s" wrote in message ... I really don't know what you mean. Could you please explain? childofthe1980s "Niek Otten" wrote: <IF($K2="F", "60"))))) And what if $K2 not equals "F"? Your formula is not complete -- Kind regards, Niek Otten "childothe1980s" wrote in message ... Hello: I'm trying to get a very simple nested IF, THEN statement to work. But, instead of returning a value, it returns "FALSE". I really don't get it. Below is my formula. Please help!!! =IF($K2="HW","70", IF($K2="SW","75", IF($K2="A","01", IF($K2="LI", "20", IF($K2="F", "60"))))) childofthe1980s |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to update a column in a work based on another work sheet | New Users to Excel | |||
how can i automatically generate work order numbers from work orde | Excel Discussion (Misc queries) | |||
flash object dont work in my excel work sheet | Excel Discussion (Misc queries) | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel |