Not sure how you are using it but if say A1 contains a number like 1.1 then
this is A2 will let you copy down as requested
=IF(RIGHT(A1,1)="8",A1+0.2,A1+0.1)
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"08Challenger" wrote:

I am looking for a cell function that allows me to icrease at a set top point
of .8
EX. 1.1, 1.2, 1.3, 1.4, 1.5, 1.6, 1.7, 1.8, 2.0, 2.1, 2.2, 2.3 etc.