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