Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-03-2017, 09:14 PM
djgrimaldi djgrimaldi is offline I need help writing an "IF" function Mac OS X I need help writing an "IF" function Office for Mac 2011
Novice
I need help writing an "IF" function
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
I need help writing an "IF" function Excel 2016 "IF" Function Problem with 3 Ranges Excelsior44 Excel 3 02-07-2017 05:46 PM
Google "=Filter()" function excel equivalent. Sadodare Excel 0 08-01-2016 11:15 AM
"one click" function to switch between branded presentations davidolone PowerPoint 0 01-16-2016 01:54 PM
Error: "The function you are attempting to run contains macros" Fadi Word 1 11-01-2011 05:25 AM
I need help writing an "IF" function How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:46 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft