View Single Post
 
Old 03-03-2017, 09:14 PM
djgrimaldi djgrimaldi is offline Mac OS X Office for Mac 2011
Novice
 
Join Date: Mar 2017
Posts: 2
djgrimaldi is on a distinguished road
Default I need help writing an "IF" function

I am trying to write a formula to input into cell R18, R19, etc.. to accomplish the following:
The function I have inserted (=IF(J18=12,M18-G18,IF(J18=13,M18-G18,2)) almost works but I am hitting a snag. Here is what I need to accomplish. Time is being entered as 100th's, not minutes.

#1 - If the number "14" is input into cell "J18, J19 etc.." and cell M34 is greater than G34, then R34 should dispaly the number "2" (representing 2 hours).

#2 - If the number "14" is input into cell "J18, J19 etc.." and cell M34 is equal or less than cell G34, then R34 should dispaly the number as a "0".

#3 - If the number "12" or "13" is input into cell "J18, J19 etc.." then M34 should dislay the result of M34 minus G34. Any negative number should display as a Zero.

"G""J""M""R"Layover StartDriver Hour ClassStart TimeLoad ReadyTime Paid19.021419.022.0019.021421.352.0019.021319.150.0219.021218.590.0019.021220.000.96
Attached Files
File Type: xlsx Driver Wait Working Copy.xlsx (15.8 KB, 10 views)
Reply With Quote