IF formula

josros60

Active Member
Joined
Jun 27, 2010
Messages
456
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
17060.52887.12AB/BC#VALUE!5%#VALUE!

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
35,764
Office Version
365
Platform
Windows
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
Joined
Dec 3, 2018
Messages
10,217
Office Version
2007
Platform
Windows
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
Joined
Dec 3, 2018
Messages
10,217
Office Version
2007
Platform
Windows
Youre welcome, thanks for the feedback
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
35,764
Office Version
365
Platform
Windows
Glad to help & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,089,766
Messages
5,410,303
Members
403,309
Latest member
chaithra

This Week's Hot Topics

Top