Hello,
I've been using Excel for years and this is the first time I've not been able to find an existing solution to a problem - normally on this forum.
I've set up an icon set - four icons.
There are three cells involved:
A2 = Comparator
B2 = Result
E1 = Tolerance
The icon should be green when Result (B2) >= Comparator (A2).
The icon should be amber when Result >= Comparator - Tolerance (in my example: =$A$2-$E$1)
The icon should be red when Result >=0
The icon should be grey when there is no value entered.
When:
Comparator = 8.7; Result = 8.5; Tolerance = 0.2
The icon is amber - which is correct as the result is within the tolerance range of 0.2.
As soon as you add 0.1:
Comparator = 8.8; Result = 8.6; Tolerance = 0.2
The icon is red - even though it should be amber as 8.8-0.2 = 8.6
You get the same result when the comparator is 8.9 and the result it 8.7, but when you get to 9.0 and 8.8 the icon turns amber.
What is it about the values between 8.8 and 8.9 that it doesn't like? I feel like I'm going slowly mad.
Any help?
Many thanks
Ben
I've been using Excel for years and this is the first time I've not been able to find an existing solution to a problem - normally on this forum.
I've set up an icon set - four icons.
There are three cells involved:
A2 = Comparator
B2 = Result
E1 = Tolerance
The icon should be green when Result (B2) >= Comparator (A2).
The icon should be amber when Result >= Comparator - Tolerance (in my example: =$A$2-$E$1)
The icon should be red when Result >=0
The icon should be grey when there is no value entered.
When:
Comparator = 8.7; Result = 8.5; Tolerance = 0.2
The icon is amber - which is correct as the result is within the tolerance range of 0.2.
As soon as you add 0.1:
Comparator = 8.8; Result = 8.6; Tolerance = 0.2
The icon is red - even though it should be amber as 8.8-0.2 = 8.6
You get the same result when the comparator is 8.9 and the result it 8.7, but when you get to 9.0 and 8.8 the icon turns amber.
What is it about the values between 8.8 and 8.9 that it doesn't like? I feel like I'm going slowly mad.
Any help?
Many thanks
Ben