Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

# Data validation if statement multiple ifs

Copper Contributor

# 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 statement work.

Any suggestions??

Thanks!

7 Replies
best response confirmed by Timbo14 (Copper Contributor)
Solution

# Re: Data validation if statement multiple ifs

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)))``

# Re: Data validation if statement multiple ifs

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

Thanks!!

# Re: Data validation if statement multiple ifs

@Timbo14 , you are welcome, glad to help

# Re: Data validation if statement multiple ifs

@Timbo14 How many if condition can be used in data validation for dependent drop-down list?

44 if condition acceptable?

# Re: Data validation if statement multiple ifs

You can nest up to 64 levels, but if you have Office 2019 or later, you can also use the IFS function.

# Re: Data validation if statement multiple ifs

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

# Re: Data validation if statement multiple ifs

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

1 best response

Accepted Solutions
best response confirmed by Timbo14 (Copper Contributor)
Solution

# Re: Data validation if statement multiple ifs

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)))``