# IF three conditions

#### mustu2

##### Board Regular
Hi

Currently i have this formula

=IF(E3="0","A","B")

i have three criteria
0
1
2

so if E3 = 0 then its A
E3=1 then its B
E3=2 then its C

thanks

### Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

#### Gerald Higgins

##### Well-known Member
Code:
``=IF(E3=0,"A",IF(E3=1,"B",IF(E3=2,"C","OTHER")))``

or, if there is no possibility that E3 is something other than 0, 1 or 2
Code:
``=IF(E3=0,"A",IF(E3=1,"B","C"))``

Thanks a lot!

#### Arul.rajesh

##### Active Member
=choose(e3+1,"a","b ","c")

#### jasonb75

##### Well-known Member

That one keeps going if you need it to, 3 = D, 25 = Z, 26 = AA, 16383 =XFD

#### mustu2

##### Board Regular
Thanks everybody for the help.

Replies
0
Views
150
Replies
4
Views
368
Replies
3
Views
413
Replies
19
Views
227
Replies
7
Views
92

1,195,662
Messages
6,011,005
Members
441,579
Latest member
satishrazdhan

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back