getting FALSE instead of blank

[Patcheen]

Hi Guys

i have this formula =IF(D9<>"",D9-G9-H9) ive also tried it with this =IF(D9<>"",SUM(D9-G9-H9))

D9 is blank but its returning FALSE instead of blank there is no formula in it only figures i input when needed as its part of a monthly accounts spreadsheet, any advise appreciated thank you

 

[footoo]

=if(d9<>"",d9-g9-h9,"")

 

[Patcheen]

Sorted thank you...... i wasn't far out thank you for your help

 

[alvisonhunter]

Let's go ahead and try this formula in the column I9: I tried to accommodate this formula based on what you explained in this post, hopefully this is close to what you are trying to achieve: Hope it helps! Greetings

=IF(ISBLANK(D3),ABS(D3-E3-F3),"")

 

[Aladin Akyurek]

Try something like...

=IF(ISNUMBER(D9),D9-SUM(G9:H9),"")