#1
|
|||
|
|||
How to create a formula using the IF in a time sheet.
Hello all I'm new to this forum and I need a little help on creating this formula. I need to add the IF as part of the formula here's what i would like to do after inputing the hours worked IF greater than 6 deduct .5, I created the formula which adds the hours, dollars and overtime.
any suggestions is appreciated. |
#2
|
||||
|
||||
Hi
perhaps post a small sample sheet showing what you want to do?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Perhaps something along these lines:
=IF(cell_ref>6,cell_ref-0.5,cell_ref) |
#4
|
||||
|
||||
Or a variation thereof:
Code:
=cell_ref-IF(cell_ref>6,0.5,0) |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Create a resource sheet in MS Project | chabuk1 | Project | 8 | 05-01-2012 12:59 PM |
create tree list in excel sheet | chuikingman | Excel | 5 | 06-27-2011 09:38 AM |
Sheet load time | markg2 | Excel | 2 | 06-01-2011 06:00 PM |
Please help me create this formula... | doublejoy | Excel | 1 | 08-22-2009 03:04 AM |
Enter Number on any sheet one time only. | paulrm906 | Excel | 1 | 04-28-2006 07:35 AM |