Formula with multiple IF(AND statements
I am having trouble with a formula that will return a 1, 3, 5, or 10 based on a combination of two columns.
Anything selected as REPORTED will equal 1. Easy enough. But in the same column, If FIXED Other points will be rewarded based on the Category it is paired with. Here is what I have so far:
=IF([Reported or Fixed?]1 = "Reported", 1, IF(AND([Reported or Fixed?]1 = "fixed", Category1 = "Find & Fix"), 5, IF(AND([Reported or Fixed?]1 = "fixed", Category1 = "Procedure Review", 3, IF(AND([Reported or Fixed?]1 = "Fixed", Category1 = "Hands Free / Ergonomics Find & Fix", 10))))))
It works for the first part of the formula, but as I added to it, it now returns INCORRECT ARGUMENT SET.
Help Article Resources
Check out the Formula Handbook template!