Forum Discussion
Help with Excel logical formula budgets vs actuals Rag staus.
Hi all, I am needing help with a formula. Confused to what would be best or could work, ifs ands or etc. I am trying to automate RAG staus. 1. If the variance of a budget vs actuals is l...
Let's say Budget is in A2 and Actual in B2.
=IF(OR(ABS(B2-A2)<=5000,ABS(B2-A2)/A2<=5%),"Green",IF(OR(ABS(B2-A2)<=10000,ABS(B2-A2)/A2<=10%),"Amber","Red"))
This can be filled down.