Forum Discussion
RAG Status help
Let's say for a budget cell a1 has the actual figure, cell b1 has the budget figure, and cell c1 has the variance figure. In d1 i need a RAG status whereby if the actual figure is over 10% of the...
Thanks for your reply, this is a good method.
What if the variance number in C had to be a number variance and not a percentage?
What if the variance number in C had to be a number variance and not a percentage?
If C2 contains the formula =A2-B2, change the formula in D2 to =C2/B2.
The rest remains the same.