IF formula

[josros60]

Hi,

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

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

here is the data:

[TABLE="width: 368"]
<tbody>[TR]
[TD="colspan: 7"]MILEAGE CALCULATION[/TD]
[/TR]
[TR]
[TD]KM[/TD]
[TD]$[/TD]
[TD]TTL $[/TD]
[TD]PROV[/TD]
[TD]÷[/TD]
[TD]%[/TD]
[TD]TAX[/TD]
[/TR]
[TR]
[TD]1706[/TD]
[TD]0.52[/TD]
[TD]887.12[/TD]
[TD]AB/BC[/TD]
[TD]#VALUE![/TD]
[TD]5%[/TD]
[TD]#VALUE![/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

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]

If the Fluff assessment is correct you can also use the following:

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

 

[josros60]

Thank you both, worked perfectly.+ Reply to Thread

 

[DanteAmor]

Youre welcome, thanks for the feedback

 

[Fluff]

Glad to help & thanks for the feedback