How to make this expression correct?

Tiger1 · 11-14-2019 10:18 AM

I need the expression to check the column first, then if it matches (is true) i need the calculation:

IF([Category_Code] = “Accessories”, [Accessories Day Rate] * [Location_Total_Count_Out_By_Category])

This currently gives me the following error:

IF function is used incorrectly:three inputs should be provided — (condition, if-result, else-result).

Bahbus

IF(
[Category_Code] = “Accessories”, 
[Accessories Day Rate] * [Location_Total_Count_Out_By_Category], 
<you need to put something here for false results>
)

If you’re going to check Category_Code against many different possibilities, you could also use a SWITCH().

SWITCH(
[Category_Code],
"Accessories",  [Accessories Day Rate] * [Location_Total_Count_Out_By_Category],
value2, result2,
value3, result3,
defaultResultIfNoMatchedValues
)

Tiger1

got it. Thanks. I will try this.

Steve

This would also work:

Tiger1

Thanks Steve…