Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am making a timesheet spreadsheet with increments of 15 minutes.
Column D = Describes Function (Lunch, Admin, Projects, Etc) Column E = Notes Column F = =IF(D4="OUT","0.00",IF(D4="lunch","0.00","0.25")) For each actual Activity I do, a value of .25 pops in for 15 minutes. For each non-work activity I do, I want 0 to pop in. My problem is the result of this formula is not coming up as a number and I am unable to add or sum the numbers together. Please help!! Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with named formula's | Excel Worksheet Functions | |||
Formulas | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |