SOLVED
Home

if then formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-358906%22%20slang%3D%22en-US%22%3Eif%20then%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358906%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20anyone%20help%20me%20with%20a%20formula%20-%20here%20is%20my%20formula%20I%20am%20looking%20for.....%20If%20G41%20is%20%26gt%3B90%20but%20%26lt%3B120%20then%20H37%20%3D%202%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20appreciate%20any%20assistance%20%3A)%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-358906%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-359142%22%20slang%3D%22en-US%22%3ERe%3A%20if%20then%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359142%22%20slang%3D%22en-US%22%3EWhen%20G41%20has%20a%20value%20of%20either%20120.5%20or%20180.5%2C%20the%20formula%20absurdly%20returns%200.%20IF%20is%20misplaced.%20The%20data%20is%20tabular%20and%20needs%20an%20approximate%20match%2C%20such%20that%20VLOOKUP%2C%20INDEX-MATCH%2C%20or%20my%20favorite%20LOOKUP%20should%20return%20the%20sensible%20answer.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-359069%22%20slang%3D%22en-US%22%3ERe%3A%20if%20then%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359069%22%20slang%3D%22en-US%22%3EWhat%20if%20G41%20%26gt%3B%3D120%20and%20%26lt%3B%3D121%3F%3CBR%20%2F%3EAlso%2C%20what%20if%20G41%26gt%3B%3D180%20and%20%26lt%3B%3D181%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-359044%22%20slang%3D%22en-US%22%3ERe%3A%20if%20then%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359044%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20the%20formula%3A%3C%2FP%3E%3CPRE%3E%3DIF(AND(G41%26gt%3B%3D90%2CG41%26lt%3B%3D120)%2C200%2CIF(AND(G41%26gt%3B%3D121%2CG41%26lt%3B%3D180)%2C300%2CIF(G41%26gt%3B%3D181%2C500%2C0)))%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20another%20one%20(Works%20in%20%3CSTRONG%3EExcel%202019%3C%2FSTRONG%3E%20and%20%3CSTRONG%3EOffice%20365%3C%2FSTRONG%3E).%3C%2FP%3E%3CPRE%3E%3DIFS(AND(G41%26gt%3B%3D90%2CG41%26lt%3B%3D120)%2C200%2CAND(G41%26gt%3B%3D121%2CG41%26lt%3B%3D180)%2C300%2CG41%26gt%3B%3D181%2C500%2CTRUE%2C0)%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-359016%22%20slang%3D%22en-US%22%3ERe%3A%20if%20then%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359016%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20Sir%2C%20That%20did%20it!!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20chance%20you%20could%20help%20with%20another%20that%20is%20similar%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehere%20is%20the%20formula%20I%20am%20looking%20for%3A%3C%2FP%3E%3CP%3EIF%20G41%20IS%20%26gt%3B90%20BUT%20%26lt%3B120%20%3D%20%24200%20OR%20IF%20G41%20IS%20%26gt%3B121%20BUT%20%26lt%3B180%20%3D%20%24300%20OR%20IF%20G41%20IS%20%26gt%3B181%20%3D%20%24500%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20so%20appreciate%20your%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-358957%22%20slang%3D%22en-US%22%3ERe%3A%20if%20then%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358957%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20need%20to%20use%20IF%20function%20along%20with%20AND%20as%20follows%3A%3C%2FP%3E%3CPRE%3E%3DIF(AND(G41%26gt%3B90%2CG41%26lt%3B120)%2C2%2C0)%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3C%2FLINGO-BODY%3E
JB_The_RV_Guy
New Contributor

Can anyone help me with a formula - here is my formula I am looking for..... If G41 is >90 but <120 then H37 = 2

 

I appreciate any assistance :) 

5 Replies
Solution

Hi,

 

You need to use IF function along with AND as follows:

=IF(AND(G41>90,G41<120),2,0)

 

Hope that helps

Thank you Sir, That did it!!!

 

Any chance you could help with another that is similar?

 

here is the formula I am looking for:

IF G41 IS >90 BUT <120 = $200 OR IF G41 IS >121 BUT <180 = $300 OR IF G41 IS >181 = $500

 

I so appreciate your help!

Hi,

 

Here's the formula:

=IF(AND(G41>=90,G41<=120),200,IF(AND(G41>=121,G41<=180),300,IF(G41>=181,500,0)))

 

Here's another one (Works in Excel 2019 and Office 365).

=IFS(AND(G41>=90,G41<=120),200,AND(G41>=121,G41<=180),300,G41>=181,500,TRUE,0)

 

Hope that helps

What if G41 >=120 and <=121?
Also, what if G41>=180 and <=181?
When G41 has a value of either 120.5 or 180.5, the formula absurdly returns 0. IF is misplaced. The data is tabular and needs an approximate match, such that VLOOKUP, INDEX-MATCH, or my favorite LOOKUP should return the sensible answer.
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies