Cell to show 0 or blank

jaycee

Active Member
Joined
Jul 22, 2009
Messages
323
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
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
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
 
Upvote 0
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
 
Upvote 0
It is good.
14.monster.gif
 
Upvote 0

Forum statistics

Threads
1,224,502
Messages
6,179,126
Members
452,890
Latest member
Nikhil Ramesh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top