Thread
:
how do i use > or = to in a formual for excel
View Single Post
#
2
Ragdyer
Posts: n/a
Try this:
=(B2840)*(B28-40)
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Fast Eddie" <Fast
wrote in message
...
i am trying to take an employee's total hours in one cell and separate
them
into regular and overtime hours, for use on the rest of the spreadsheet.
The formula for regular time looks like: =B28 and for the overtime I have
been trying to use: =B28+-40 This works fine for 40 hours or more. When
the
employee works less than 40 however it returns a negative number which
throws
off the rest of the information in the sheet. i think i need a way to use
=(B28 +-40) if or=0
does anyone have any ideas?
Thanks in advance!
Reply With Quote