Thank you! I tried both of these, but got the same message for both:
"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."
(I'm using Formula - User, so not sure why this wouldn't work!)
