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

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

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