Report

If Statements [Solved]

Ask a question Aztec - Last answered 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

Member requests are more likely to be responded to.

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

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!