Help with a Formula - Might be IF

I am looking for a formula to do the following. I believe it is an "IF", but not sure. I basically want a formula to return results based on the following: If the cell with the number is <=...

excel

Formulas and Functions

Haytham Amairah
May 27, 2019
Hi,

You need to IF along with AND to do this as follows.
=IF(A1<=50,A1*2,
IF(AND(A1>50,A1<=100),A1*1.75,
IF(AND(A1>100,A1<=200),A1*1.5,"N/A")))

Hope that helps

bengal1022

Haytham Amairah

Silver Contributor

May 27, 2019

Hi,

You need to IF along with AND to do this as follows.

=IF(A1<=50,A1*2,
IF(AND(A1>50,A1<=100),A1*1.75,
IF(AND(A1>100,A1<=200),A1*1.5,"N/A")))

Hope that helps

bengal1022

Copper Contributor

May 28, 2019

This worked.

Thank You!

Forum Discussion

Help with a Formula - Might be IF