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