Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Don't want 0.00
I have a timesheet workbook.
Column N contains hours worked Columns S-V is where I enter other types of paid leave used I use this formula in H22 to calculate how much vacation time I used in a pay period and it works fine with one exception: =MAX(0,80-(SUM(N8:N12,N15:N19))-SUM(S8:V12,S15:V19)) The exception occurs if I work any total of 80 hours Problem: with this scenario 0.00 is displayed in H22 rather than remaining blank (I have 'Window options' 'Zero values' unchecked). How can I keep that from happening? -- David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate totals | Excel Discussion (Misc queries) | |||
import multiline data from text file | Excel Discussion (Misc queries) | |||
How to cause the value in the denominator change with changing row | Excel Discussion (Misc queries) | |||
Currency formula/formatting problem | Excel Discussion (Misc queries) | |||
Autofill/Reference Confusion | Excel Worksheet Functions |