Formula

G

Guest

Hi Guys,

Can anyone help with the following formula, I can write may argument but
cannot get the formula to work?

if cell F5 is 50% or less then Cell G5 = Red
if cell F5 is greater the 50% & less then 75% then Cell G5 = Amber
If cell F5 is greater the 75% Cell G5 = Green


Thanks in advance,

Chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional formatting help required. 2
formula help 4
Display result depending on value entered 3
Adding cells but leaving blank if not populated 1
iferror 13
Help with RAG Formula 4
simple If but not for me 3
need to subtract .50 from a cell if it is over 6.00 4

Top