Forum Discussion

Timbo14's avatar
Timbo14
Copper Contributor
Jul 31, 2019

Data validation if statement multiple ifs

=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 ...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Jul 31, 2019

    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)))
SergeiBaklan's avatar
SergeiBaklan
MVP
Jul 31, 2019

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)))
shaik1520's avatar
shaik1520
Copper Contributor
Aug 31, 2023

SergeiBaklan in excel sheet generate formula if x3=Gen dist wide Selected from a drop down then y3=data validation(M2:M5)

  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Aug 31, 2023

    shaik1520 

    Sorry, I didn't catch what do you mean. Could you provide sample file or at least screenshot?

Resources