|
|
#1
12-03-2013, 08:08 AM
|
|||
|
|||
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 
|
| Tags |
| if than formula |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| A formula to Take what I need from a cell and add the rest | bremen22 | Excel | 2 | 11-21-2013 08:05 AM |
 formula help with total in same cell
|
jterr | Excel | 14 | 02-25-2013 05:43 PM |
| Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |
|
Formula in a Cell with condition?
|
Learner7 | Excel | 1 | 07-19-2010 10:10 AM |
|
Protect formula in cell?
|
markg2 | Excel | 4 | 05-24-2010 11:50 AM |
Windows Vista 
Office 2010 64bit
Threaded Mode