SOLVED

Data validation if statement multiple ifs

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
best response confirmed by Timbo14 (New Contributor)
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