# Simple IF

#### hsandeep

##### Well-known Member
B2=Either of 2 or 1
C2=Either of 1 or 0

D2=100 for B2=2 & C2=1 else 200 for B2=1 & C2=1 else 300.

Formula needed for D2?

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

#### gaz_chops

##### Well-known Member
Try

=if(and(B2=1,C2=1),200,if(and(B2=2,C2=1),100,300))

#### hsandeep

##### Well-known Member
Try

=if(and(B2=1,C2=1),200,if(and(B2=2,C2=1),100,300))

It WORKS. Thanks

You're welcome.

Replies
5
Views
216
Replies
5
Views
199
Replies
4
Views
346
Replies
4
Views
158
Replies
24
Views
683

1,195,650
Messages
6,010,920
Members
441,572
Latest member
keobongda8812

### 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