Hi
I am using this formula on a 'helper column' (G) to try to produce 3 values, G, R and A on which I want to apply conditional formatting traffic light icons.
All would be well if one of the criteia in my formula was not a negative percentage value: =IF(H32>=15%,"G",IF(H32<=15%,"A",IF(H32<-15%),"R","")))
It works apart from the last nested IF statement which does not seem to be recognised.
The cells with the values it is using are generated from this formula to produce percentages: =IFERROR((E32-C32)/C32,"0.00%")*-1
So it too has a negative but I have tried all sorts of permuations in case that was it.
Is what I am trying to do impossible or is there another way to do it?
Than ks in advance for any help.
I am using this formula on a 'helper column' (G) to try to produce 3 values, G, R and A on which I want to apply conditional formatting traffic light icons.
All would be well if one of the criteia in my formula was not a negative percentage value: =IF(H32>=15%,"G",IF(H32<=15%,"A",IF(H32<-15%),"R","")))
It works apart from the last nested IF statement which does not seem to be recognised.
The cells with the values it is using are generated from this formula to produce percentages: =IFERROR((E32-C32)/C32,"0.00%")*-1
So it too has a negative but I have tried all sorts of permuations in case that was it.
Is what I am trying to do impossible or is there another way to do it?
Than ks in advance for any help.