Multiple IF statements in Excel [Solved]

nesto2008 1 Posts Sunday July 15, 2018Registration date July 15, 2018 Last seen - Jul 15, 2018 at 06:57 PM - Latest reply:  Nesto2008
- Jul 17, 2018 at 11:20 AM
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

2 replies

TrowaD 2435 Posts Sunday September 12, 2010Registration dateModeratorStatus October 8, 2018 Last seen - Jul 17, 2018 at 11:18 AM
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