Based on the pattern,
it looks like you're wanting to round UP to the next increment of 5
However, there's might be a small problem.
Are the numbers you're testing really %'s?
That is..
is 50.3 really .503 represented as 50.3%
or is it actually 50.3 and you're just CALLING it a %?
If it's reall
Hi,
I didn't get what exactly you want. But attached solutin file as per my
understanding.
You cannot have more than 7 nested If conditions so I have used different
formula.
Formula:
=IF(A2>50, IF(MROUND(A2, 5)wrote:
> hi Group
>
> Can u please help me out in this problem. I have an query of
