I am new to Excel and need help with a formula.

If 0% is paid then it needs to be coded to 10, and so forth... Right now the data does not match, for example I have 0% in the paid column and the code column will show up with any value 8, 9, 7

If X= 10 then, Y = 0%

If X= 9 then, Y = between 1% to 25%

If X= 8 then, Y = between 26% to 99%

If X=7 the, Y= 100%

This needs to be true in reverse as well.

IF(A2=0%,"10",IF(AND(A3>=1%,A3<25%),"9")) Is this accurate? Is there a cleaner, easier way? How do I produce this in Power Query?

Hope this makes sense

Thank you