Hi everyone, I would like to do a calculation but can only get half the answer as it must return a total if >0 and if 0 then the cell must be blank
Cell F44 is a date.
Cell H45 is to be the result
Formula I have. =IF(F44>0,F44+63)
The result H45 is date +63 gives new date that part works.
Failed result at H45 is FALSE and I require H45 to be empty when F44=0.
Can any one help as this is beginning to drive me nuts.
Thanks in advance
Michael
Cell F44 is a date.
Cell H45 is to be the result
Formula I have. =IF(F44>0,F44+63)
The result H45 is date +63 gives new date that part works.
Failed result at H45 is FALSE and I require H45 to be empty when F44=0.
Can any one help as this is beginning to drive me nuts.
Thanks in advance
Michael