Thread: [Solved] Formula in cell b1 using cell a1 if a1 is over certain number
View Single Post
 
Old 12-03-2013, 08:08 AM
pumkinbug87 pumkinbug87 is offline Windows Vista Office 2010 64bit
Novice
  
Join Date: Dec 2013
Posts: 4
pumkinbug87 is on a distinguished road
Default Formula in cell b1 using cell a1 if a1 is over certain number
I need help creating a formula.
This is for a timesheet -
in Cell A1, employee types number of hours worked.
In Cell A2 is the formula for the Earned Comp Time (Time and Half = A1*1.5)

I only want the formula to work IF the number of hours in Cell A1 exceed 8 Hours. If 8.0 or less, I don't want anything to show in Cell A2

I.E.


Hrs Worked........|..8....|....12
Comp Earned......|.._....|....18

Any help making this IF formula would be helpful!
Last edited by pumkinbug87; 12-03-2013 at 08:31 AM. Reason: The excel table did not format
Reply With Quote