Help with a excel problem

[Alvin43047]

Hi All, New to the Forum so Hello to everyone.
I am looking for a formula or formatting condition that will add 0.2 to a cell that ends in .80 to .99 but will not change if its below .80.
For example if a cell contains 26.89 I want it to show 27.09 and if it shows 17.69 I want it to remain the same.
I am sure this is possible but I have tried everything and I am at a total loss.

Thank You.
regards
Alvin

 

[mumps]

Try: =IF(AND(A1>=0.8,A1<=0.99),A1+0.2,"")

 

[Aladin Akyurek]

=a2+if(and(mod(a2,1)>=0.8,mod(a2,1)<=0.99),0.2,0)

 

[Alvin43047]

Fantastic guys, Exactly what I was looking for.
Thank you so much.
Regards
Alvin