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:

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

<tbody>
</tbody>

 

[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