Report

If Statements [Solved]

Ask a question Aztec - Latest answer on May 23, 2016 04:37PM
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.
thanks in advance guys!
See more 
Helpful
+0
moins plus
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!
Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!