Thread: nested ifs

i want to show a formula for the following...

if the cell is less than 97% show "1" BUT IF THECELL IS BLANK do not show any value

at present when i do an IF and cell value is less than 97 it picks up not only those with a value but those with no value as well and registers them as below 97%

If your data is in cell A1, say, then try - =IF(AND(NOT(ISBLANK(A1)),A1<97%),"1","") or =IF(AND(ISNUMBER(A1),A1<97%),1,"")

Legend.... Thanks