SOLVED
Home

Data validation if statement multiple ifs

%3CLINGO-SUB%20id%3D%22lingo-sub-781835%22%20slang%3D%22en-US%22%3EData%20validation%20if%20statement%20multiple%20ifs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-781835%22%20slang%3D%22en-US%22%3E%3CP%3E%3DIF(A3%3D%22850%20HP%22%2CA7%26gt%3B16.74)%3DIF(A3%3D%22425%20HP%22%2CA7%26gt%3B11.99)%3DIF(A3%3D%E2%80%9D850%20LPHP%E2%80%9D%2C%20A7%26gt%3B13.24)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20force%20a%20different%20minimum%20entry%20value%20in%20A7%20from%20a%20Drop%20down%20list%20vaule%20in%20A3.%20I%20can%20only%20make%20one%20if%20statement%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestions%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-781835%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-781944%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20validation%20if%20statement%20multiple%20ifs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-781944%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F385087%22%20target%3D%22_blank%22%3E%40Timbo14%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt's%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-ruby%22%3E%3CCODE%3E%3DIF(A3%3D%22850%20HP%22%2CA7%26gt%3B16.74%2CIF(A3%3D%22425%20HP%22%2CA7%26gt%3B11.99%2CIF(A3%3D%22850%20LPHP%22%2C%20A7%26gt%3B13.24%2CTRUE)))%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-782079%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20validation%20if%20statement%20multiple%20ifs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-782079%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWorks%20like%20a%20charm!!%20I've%20spent%20over%20a%20day%20trying%20different%20things%20and%20could%20not%20come%20up%20with%20a%20solution.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20the%20best!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-782286%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20validation%20if%20statement%20multiple%20ifs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-782286%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F385087%22%20target%3D%22_blank%22%3E%40Timbo14%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%2C%20glad%20to%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E
Timbo14
New Contributor

=IF(A3="850 HP",A7>16.74)=IF(A3="425 HP",A7>11.99)=IF(A3=”850 LPHP”, A7>13.24)

 

I'm trying to force a different minimum entry value in A7 from a Drop down list vaule in A3. I can only make one if statement work.

 

Any suggestions??

 

Thanks!

3 Replies
Solution

@Timbo14 

It's like

=IF(A3="850 HP",A7>16.74,IF(A3="425 HP",A7>11.99,IF(A3="850 LPHP", A7>13.24,TRUE)))

@Sergei Baklan 

 

Works like a charm!! I've spent over a day trying different things and could not come up with a solution.

 

Your the best!

 

Thanks!!

@Timbo14 , you are welcome, glad to help

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