# IF formula

#### josros60

##### Well-known Member
Hi,

I have this IF formula but give me error "#VALUE!" here is the code:

Code:
``=IF(AND(L4="AB/BC","QC"),K4/1.05,K4/1.13)``

here is the data:

 MILEAGE CALCULATION KM \$ TTL \$ PROV ÷ % TAX 1706 0.52 887.12 AB/BC #VALUE! 5% #VALUE!

<tbody>
</tbody>

### Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

#### Fluff

##### MrExcel MVP, Moderator
If you mean if L is AB/BC or its QC try
=IF(OR(L4="AB/BC",L4="QC"),K4/1.05,K4/1.13)

#### DanteAmor

##### Well-known Member
If the Fluff assessment is correct you can also use the following:

=IF(OR(L4={"AB/BC","QC"}),K4/1.05,K4/1.13)

#### DanteAmor

##### Well-known Member
Youre welcome, thanks for the feedback

#### Fluff

##### MrExcel MVP, Moderator
Glad to help & thanks for the feedback

Replies
1
Views
64
Replies
8
Views
102
Replies
3
Views
165
Replies
4
Views
119
Replies
3
Views
100

1,132,664
Messages
5,654,633
Members
418,145
Latest member
Waqar804

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