Multiple IF statements in Excel

Solved/Closed

nesto2008 Posts 1 Registration date Sunday 15 July 2018 Status Member Last seen 15 July 2018 - 15 Jul 2018 à 18:57
Nesto2008 - 17 Jul 2018 à 11:20

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 to copy data from one excel sheet to another - Guide
Export data from excel - Guide
How many if statements can you nest in excel - Guide
Excel mod apk for pc - Download - Spreadsheets
Excel move data from one sheet to another - Guide

1 response

Réponse 1 / 1

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
17 Jul 2018 à 11:18

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
17 Jul 2018 à 11:20

Thank you so much.

Similar discussions

Excel - IF function with multiple words

Copying data from one Excel sheet to another.

Hosted app data will not clear

How to extract data from one excel file to another

Similar discussions

Subscribe To Our Newsletter!