Hi,
I have this IF formula but give me error "#VALUE!" here is the code:
here is the data:
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>