If Statements [Solved/Closed]

Aztec - May 23, 2016 at 09:23 AM - Latest reply: ac3mark 9199 Posts Monday June 3, 2013Registration dateModeratorStatus April 23, 2018 Last seen
- May 23, 2016 at 04:37 PM
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 

1 reply

ac3mark 9199 Posts Monday June 3, 2013Registration dateModeratorStatus April 23, 2018 Last seen - May 23, 2016 at 04:37 PM
0
Helpful
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!