DharmeshChauhan
New Member
- Joined
- Apr 25, 2022
- Messages
- 16
- Office Version
- 365
- Platform
- 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?
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 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | |||||
2 | |||||
3 | Total Number Of Days - (25) | Bank Holiday's (Minus) | Total Booked - After BH | ||
4 | 5 | 1 | 4 | ||
5 | 3 | 1 | 2 | ||
6 | 0 | ||||
7 | 0 | ||||
8 | 0 | ||||
9 | 0 | ||||
10 | 5 | 5 | |||
11 | 5 | 5 | |||
12 | 0 | ||||
13 | 0 | ||||
14 | 0 | ||||
15 | 0 | ||||
16 | 0 | ||||
17 | 0 | ||||
18 | 0 | ||||
19 | 5 | 5 | |||
20 | 21 | ||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C4:C19 | C4 | =A4-B4 |
C20 | C20 | =SUM(C4:C19) |