If Statements

Aztec - May 23, 2016 at 09:23 AM
 Blocked Profile - May 23, 2016 at 04:37 PM
I have a scenario working with a time sheet. So basically the way payments work is from 30 minutes to 5 hours is automatically 5 hours of work no matter what. If it is 5.5 to 10 it is automatically calculates as 10 hours. Anything past that is over time. So I need to take the totals from 2 sets of In & Out punch times. If the total is more than 0 but equal to or less than 5, it should display as 5 & if it is greater than 5 but equal to or less 10 it should display 10. Technically for this purpose i can have 5.5 and up be shown as 10 since there will be a separate Overtime Column

For this example lets assume I have a total for the time sheet hours in Cell C1 and D1 will contain the formula to display either 5 or 10 hours.

thanks in advance guys!

1 response

Blocked Profile
May 23, 2016 at 04:37 PM
The formula for IF is:
=IF(logic_test,true, false)

You can nest If statement like so:


I hope this helps!

Post back with your formula if this doesn't help out!