Forum Discussion

Iron Contributor

Jun 13, 2022

Solved

IF FUNCTION

Hello Everyone, If the formula provides a result less than 10, I want the result to be 10. If the formula provides a result greater than 15, I want the result to be 15. If the result is in-between ...

Book4.xlsx8 KB

excel

Formulas and Functions

Riny_van_Eekelen
Jun 13, 2022
Excel Try this:
=MAX(10,MIN(A1,15))

Riny_van_Eekelen

Platinum Contributor

Jun 13, 2022

Excel Try this:

=MAX(10,MIN(A1,15))

Excel

Iron Contributor

Jun 13, 2022

Thank you so much sir.