Multiple IF statements in Excel

Solved/Closed
nesto2008 Posts 1 Registration date Sunday July 15, 2018 Status Member Last seen July 15, 2018 - Updated on Jul 17, 2018 at 11:27 AM
 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

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jul 17, 2018 at 11:18 AM
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
0
Thank you so much.
0