Unwanted 'FALSE' (1 Viewer)

BobNTN

Registered User.
Local time
Today, 13:03
Joined
Jan 23, 2008
Messages
308
=IF(ISNUMBER(F9),IF(SUM(F9-E9)>=0,ROUNDUP(SUM(F9-E9)/2,0)+E9,IF(SUM(E9-F9)>1,(E9-1),E9)))
This formula is in cell G9. It works fine except if there is no entry in cell F9, it displays the word FALSE. I want it to remain blank until there is an entry into F9. I have tried incorporating the "" every way I can think of but get arguement errors.
What am I missing here ?
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 01:03
Joined
May 7, 2009
Messages
19,230
=if(isnumber(f9),if(sum(f9-e9)>=0,roundup(sum(f9-e9)/2,0)+e9,if(sum(e9-f9)>1,(e9-1),e9)),"")
 

BobNTN

Registered User.
Local time
Today, 13:03
Joined
Jan 23, 2008
Messages
308
=if(isnumber(f9),if(sum(f9-e9)>=0,roundup(sum(f9-e9)/2,0)+e9,if(sum(e9-f9)>1,(e9-1),e9)),"")

Thanks. I really appreciate that.
 

Users who are viewing this thread

Top Bottom