why If, THEN does not work

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
<IF($K2="F", "60")))))>

And what if $K2 not equals "F"?

Your formula is not complete
 
=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
 
=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)
 
Back
Top