Formula That Does Show a Zero

DharmeshChauhan

New Member
Joined
Apr 25, 2022
Messages
16
Office Version
  1. 365
Platform
  1. Windows
Hi

I am currently creating a holiday planner, and I have a columns that show the number of days the employee has taken (column A), then another column which has minus Bank holidays (column B) (see below image) but where no numbers are in the columns the formula is showing a zero (column C) , can the formula be edited so that it doesn't show the zero?

Mini Table - 2023.xls
ABC
1
2
3Total Number Of Days - (25)Bank Holiday's (Minus)Total Booked - After BH
4514
5312
60
70
80
90
1055
1155
120
130
140
150
160
170
180
1955
2021
Sheet1
Cell Formulas
RangeFormula
C4:C19C4=A4-B4
C20C20=SUM(C4:C19)
 

Attachments

  • Holidays Capture.PNG
    Holidays Capture.PNG
    8.5 KB · Views: 4

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
How about
Excel Formula:
=IF(A4="","",A4-B4)
 
Upvote 0
Like this?

22 12 29.xlsm
ABC
1
2
3Total Number Of Days - (25)Bank Holiday's (Minus)Total Booked - After BH
4514
5312
6 
7 
8 
9 
1055
1155
12 
13 
14 
15 
16 
17 
18 
1955
2021
Sheet3
Cell Formulas
RangeFormula
C4:C19C4=IF(A4&B4="","",A4-B4)
C20C20=SUM(C4:C19)
 
Upvote 0
Solution

Forum statistics

Threads
1,213,489
Messages
6,113,947
Members
448,534
Latest member
benefuexx

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