what am i doing wrong?

[mccallda]

hi everyone, i know i am being stupid but i cannot get this formula to work..... i am doing a nested if formua and i can get it to work, but i cant seem to report back if when a cell is blank it to report back an error.

for example, if(cell> cell),"True","false") but i how do i get it to add if the cell is blank report back blank?

i have tried a few things and i cannot seem to add this in and it is driving me up the wall. i know its simple and i will slap myself for this but help!!

 

[xenou]

Two IF formulas will work, one nested in the other - the first to test for blank, the second to either compare values or return your error message:
=IF(ISBLANK(cell),"#ERROR#",IF(cell>cell,TRUE,FALSE))

I often use LEN() but that's probably not as common as the above solution:
=IF(LEN(cell),IF(cell>cell,TRUE,FALSE),"#ERROR#")