I need formula help please:
How do I say "if the value in this field is not blank show me this...? I've been trying to use the not isnull function, but no luck. I'm not sure what I'm doing wrong. This is the formula so far: Case...
Forum Discussion
Nope, it's throwing me back an error message.
Formula error -- Bad or missing arguments in function call
The types of the arguments or the number of arguments supplied do not meet the requirements of the function If.
The function is defined to be If (Boolean condition1, result1, ..., else-result).
You may need to do one of the following to fix the problem:
Formula error -- Bad or missing arguments in function call
The types of the arguments or the number of arguments supplied do not meet the requirements of the function If.
The function is defined to be If (Boolean condition1, result1, ..., else-result).
You may need to do one of the following to fix the problem:
- Choose the right number and type of arguments.
- Use a type conversion function to convert the arguments you are using to the correct type.
- Choose a different function.
So, let's go with a full on IF()
If(
[Inventory Item Name]="", [Edit Price],
not isnull([Inventory Item Name]),[Quantity Proposed]*[Inventory Item - Rental Price Per Unit],null
)