IF OR NESTED STATEMENT
Can someone help with If statement.
Column A - text entered will be Audit or Review
Column B - numbers 0 and higher
Column C - If A = "audit" and B is = or 200 then C results as A-200 OR If
B = "review" and B is = or 60 then C results as C-60
Many thanks!
|