help with formula please

Si Spence · 02/18/19

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 · 02/18/19

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 · 02/18/19

Thanks Paul, this worked a treat.

Paul Newcome · 02/18/19

Happy to help.

help with formula please

Comments

Help Article Resources

Categories