Unwanted 'FALSE' (1 Viewer)

BobNTN

Registered User.
Local time
Yesterday, 19:55
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
Today, 07:55
Joined
May 7, 2009
Messages
19,229
=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
Yesterday, 19:55
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