Cell to show 0 or blank

[jaycee]

I have a cell I8 that has the formula F8-C8+1, I need this to show either 0 or blank if there is nothing in F8 & C8.
Sometimes the number in Both F8 and C8 will be the same therefore the answer will be 1 that is why I cannot use Cinditional formatting to hide

Cheers

 

[BeingYogi]

May Be:


=if(Or(F8=0,C8=0),"",F8-C8+1)

 

[villy]

Try this..

=IF(AND(ISBLANK(F8),ISBLANK(C8)),0,F8-C8+1)

 

[jaycee]

Beingyogi, that formula does not work on the spreadsheet.
Villy your formula shows 0 butit will not deduct the sum of C8 from F8 as it still shows 0

Cheers

 

[jaycee]

My apologies to you both,

I have now managed to get this to work, Mu mistake, put it in the wrong cell, Had a merged cell and did not notice

Many thanks for your help

 

[villy]

Villy your formula shows 0 butit will not deduct the sum of C8 from F8 as it still shows 0

Cheers

Care to check again because it works for me...
Thanks

 

[babypp2]

It is good.