Multiple IF statements in Excel [Solved]

Posts
1
Registration date
Sunday July 15, 2018
Last seen
July 15, 2018
-
Hello,

I am trying to calculate a cell based on values ,

so if A1 =between 1 to 10 than it will equal 10.00
if A1 = between 11 to 20 that it equals 11.00
if A1 = 21 to 30 that it equals 12.00 and so on

APPRECIATE THE RESPONCES !!

THANKS
See more 

Your reply

1 reply

Posts
2440
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 13, 2018
0
Thank you
Hi Nesto,

Try this:
=IF(AND(A1>=1;A1<=10);10;IF(AND(A1<=11;A1>=20);11;IF(AND(A1>=21;A1<=30);12;"Not defined")))

Best regards,
Trowa
Respond to TrowaD