Home |
Search |
Today's Posts |
#1
|
|||
|
|||
My formulas does not sum together
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 |
#2
|
|||
|
|||
take the quotes off your numbers
=IF(D4="OUT",0,IF(D4="lunch",0,0.25)) "Catherine" wrote: 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 |
#3
|
|||
|
|||
Thank you so much. I feel like an idiot! I don't really have any knowledge
of formulas. I just basically copy them from the help files. So thank you, everything works perfectly. "Catherine" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |