How do I apply icon sets to percentage values in Excel worksheet?

[Still Learning?]

When applying arrow icon sets as conditional formatting in a worksheet, where
the values are expressed as percentages (as a result of a formula) the arrows
that are shown DO NOT match the what they should be based on the values that
I enetered for each range.

(It appears that Excel is using a Percentile basis not the actual
percentages!?!) Is there a way to fix this?

Thank you for any insight that may be offered.

 

[Max]

One guess - it's the underlying calculated value/s

You could try using ROUND,
eg something like this in the CF's formula:
=round(A1,2)>0.5

instead of: =A1>0.5