Hello All -

I am trying to get my head around this and have not been able to, so hopefully someone can help me out.

I have a number is Cell F5 and I need to check to see if it is divisible by 20%

If that number is divisible by 20% I need to divide it by 20%
If it is not divisible by 20% I need to round it down to be divisible by 20% and display that value in cell G5. I know that is hard to read but I do not know how else to explain it.

Basically if I have a number in F5 - Let’s say a 5, I know that is evenly divisible by 20% so the value is 1

But if the number in F5 is let’s saying a 7, I need G5 to display the value as if it was a 5.

Thanks for the help - if it can even be done.