# If Statements [Solved/Closed]

Ask a question Aztec - Last answered on May 23, 2016 at 04:37 PM by ac3mark
Hello,
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.

+0
The formula for IF is:
\
=IF(logic_test,true, false)

You can nest If statement like so:

=IF(logic_test,IF(another_logic_test_if_first_was_true,Second_true,If_second_is_false),First_logic_test_false)

I hope this helps!

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

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.