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

Multiple if statements in excel data validation
Display two columns in data validation list but return only one - Guide
Transfer data from one excel worksheet to another automatically - Guide
Number to words in excel - Guide
How many nested if statements in excel - Guide
Tmobile data check - Guide

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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

Nesto2008
Jul 17, 2018 at 11:20 AM

Thank you so much.

Similar discussions

Unlock safe folder without losing any data

How To Fix Mint Mobile Data Not Working?

Similar discussions

Subscribe To Our Newsletter!