Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Logical Formula
I have the following formula
=IF(AND(J5<316226),"Green",IF(AND(J5=3162277),"Re d",IF(AND(J5=316228),"Amber",IF(AND(J5<=3162276), "Amber")))) I'd like to include the comment "NO DATA" if the ref cell is not populated with a value. I thought " " ment empty cell but I can't get it to work. Thanks in advance for your help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel displaying formulae as constant and not calculating formula | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions |