Thomas Kuriakose
Active Member
Respected Sirs,
We have a list of percentages that need to be grouped.
The percentage format (74.35%) is not getting grouped and I tried to use the number to apply grouping and was partially successful.
The below lookup is giving result for all positive values but for negative it is #N/A.
=LOOKUP(A3,{0,0.05,0.1,0.15,0.2,0.25,0.3,0.35,0.4,0.45,0.5,0.55,0.6,0.65,0.7,0.75,0.8,0.85,0.9,0.95,1},$D$3:$D$23)
Kindy guide in the attached file on how to get the results with percentage format and f negative values.
Thank you very much for you support always,
with regards,
thomas
We have a list of percentages that need to be grouped.
The percentage format (74.35%) is not getting grouped and I tried to use the number to apply grouping and was partially successful.
The below lookup is giving result for all positive values but for negative it is #N/A.
=LOOKUP(A3,{0,0.05,0.1,0.15,0.2,0.25,0.3,0.35,0.4,0.45,0.5,0.55,0.6,0.65,0.7,0.75,0.8,0.85,0.9,0.95,1},$D$3:$D$23)
Kindy guide in the attached file on how to get the results with percentage format and f negative values.
Thank you very much for you support always,
with regards,
thomas