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
How many if statements can you nest - Guide
Excel data validation list from table multiple columns - Guide
Transfer data from one excel worksheet to another automatically - Guide
Excel date format dd.mm.yyyy - Guide
If then statements in excel - Guide

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 549
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

using multiple if functions with data validation

Excel - IF function with multiple words

How to calculate positions (1st,2nd,3rd...) in Excel

How to use conditional format based on text?

Similar discussions

Subscribe To Our Newsletter!