| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i keep cells blank until the formula is used?
I am working on a timesheet that add time and calculates cost. The formula I
am using for column I of the timesheet (which can be used for up to three in/out times per day) is "=SUM((D12-C12)*24,(F12-E12)*24,(H12-G12)*24)". Column J calculates cost using the formula "=I12*B12" where column B is the hourly fee. My question is, how can I get columns I and J to be blank until they are needed. Right now they fill with "0.00" and "$0.00." |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula that returns Col A data in Col B, but omitting blank cells | Excel Worksheet Functions | |||
| how can I count blank cells as a zero, when using formula please?? | Excel Worksheet Functions | |||
| How do you nest the following formula to show blank cells | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Threaded Mode
