IF formula

josros60

Active Member
Joined
Jun 27, 2010
Messages
437
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>
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,533
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
7,920
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
7,920
Office Version
2007
Platform
Windows
Youre welcome, thanks for the feedback
 

Fluff

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

Forum statistics

Threads
1,078,450
Messages
5,340,357
Members
399,371
Latest member
wilbot

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top