View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default How can I get the value of a cell to increase in steps?

If you had the formula =IF(A1100,"good","bad")

and you wanted to add 1 to cell A1, it could read

=IF((A1+1)100,'Good","bad")


Vaya con Dios,
Chuck, CABGx3




"Hawkeye" wrote:

I want a formula where in a logic statement, I can automatically increase the
value of a cell by one.