Forum Discussion
Solved
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 ...
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)))
Timbo14 How many if condition can be used in data validation for dependent drop-down list?
44 if condition acceptable?
You can nest up to 64 levels, but if you have Office 2019 or later, you can also use the IFS function.