help with formula please

Si Spence

I have a percentage in a cell that has been derived by subtracting one percentage from another. ie 5% - 10% = -5% and I now want to represent this answer as a R A G coloured blob symbol, where:

< -4.99% = G

-5.00% to -9.99% = A

 > -10.00% = R

Is thsi doable pls?...Thank you.

Paul Newcome

Try this...

 

=IF([Column Name]@row < -.1, "Red", IF([Column Name]@row < -.05, "'A' Color", "Green"))

 

Just change [Column Name] to the correct column reference. Also... I am not sure what "A" stands for, so you'll need to adjust that to the correct Color name.

Si Spence

Thanks Paul,   this worked a treat.

Paul Newcome

Happy to help.