# Formula Help

##### Well-known Member
Hey Guy's I need a formula in cell D1 that performes this function??
Book1
ABCD
1??????
2
3IfA1=1andB1=1or2,then1.5%*C1
4IfA1=2or3then\$0
5IFA1=4andB1=1or2,then1.0%*C1
Sheet1

### Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

#### MBinMTL

##### New Member
I might be off by a parantheses or two but this is the jist of it. Good luck

=if(AND(A1=1,OR(B1=1,B1=2)),C1*0.015,if(OR(A1=2,A1=3),0,if(AND(A1=4,OR(B1=1,B1=2)),C1*0.01,NA())))

#### Oaktree

##### MrExcel MVP
What happens if A1 = 1 or 4 but B1 does *NOT* equal 1 or 2?

##### Well-known Member
Well cell B1 will always be either 1,2 or 3 IF 3 =\$0

#### SteveO59L

##### Well-known Member
Try

=IF(AND(A1=1,OR(B1=1,B1=2)),C1*0.015,IF(OR(A1=2,A1=3),0,IF(AND(A1=4,OR(B1=1,B1=2)),C1*0.01,"Something Else")))

##### Well-known Member
Try

=IF(AND(A1=1,OR(B1=1,B1=2)),C1*0.015,IF(OR(A1=2,A1=3),0,IF(AND(A1=4,OR(B1=1,B1=2)),C1*0.01,"Something Else")))

This one seems to do what I need, actually the other one did also, but I couldn't get the N/A to be 0 when "3" was entered

#### Oaktree

##### MrExcel MVP
Try:

=C1*CHOOSE(A1,OR(B1=1,B1=2)*1.5%,0,0,OR(B1=1,B1=2)*1%)

##### Well-known Member
Try:

=C1*CHOOSE(A1,OR(B1=1,B1=2)*1.5%,0,0,OR(B1=1,B1=2)*1%)

That works GREAT, thank you

Replies
6
Views
236
Replies
5
Views
251
Replies
3
Views
270
Replies
47
Views
4K
Replies
1
Views
477

1,181,658
Messages
5,931,270
Members
436,785
Latest member
KingGideon

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