DanielBellfield
New Member
- Joined
- Mar 16, 2012
- Messages
- 36
Good afternoon all,
Looking for some help on the below. Basically i am trying to get the cell to be blank if there is no date in another coloum. It works fine, but if the cell above it is also blank it displays #value. The dates change accoarding to month and therefore i want to keep the formula the same but edit the dates.
Heres where i'm upto.
<tbody>
</tbody>
Help please!
Thank you.
Dan
Looking for some help on the below. Basically i am trying to get the cell to be blank if there is no date in another coloum. It works fine, but if the cell above it is also blank it displays #value. The dates change accoarding to month and therefore i want to keep the formula the same but edit the dates.
Heres where i'm upto.
Order Intake | ||||
Month: | ||||
Daily Target: | 17500 | |||
Daily Total | Running Total | Daily Average Running Total | ||
Monday | =IF(C5="","",C5) | =IF(B5=0," ",$B$3) | ||
Tuesday | =IF(C6="","",C6+D5) | =IF(B6=0," ",$B$3+E5) | ||
Wednesday | =IF(C7="","",C7) | =IF(B7=0," ",$B$3+E6) | ||
Thursday | =IF(C8="","",C8+D7) | =IF(B8=0," ",$B$3+E7) | ||
Friday | 42552 | =IF(C9="","",C9) | =IF(B9=0," ",$B$3+E8) |
<tbody>
</tbody>
Help please!
Thank you.
Dan