=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 ?
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 ?