I can't figure out what I am doing wrong. Please help.
• IF K27 is equal to 0, then ELEPHANT,
• IF K27 is greater than 0, then LION
• IF K27 is greater than 0 and E45 is greater than 0, then TIGER
=IF(K27=0, “ELEPHANT”, IF(K27>0, “LION”, IF(AND(K27>0, E45>0), “TIGER”))))
Why oh why doesn't this work? THANK YOU!
Bookmarks