View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default octogonal repeat?

=IF((MOD(A1,1)<=0.8),A1+0.1,INT(A1)+1)


"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.