Formula help please

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

G'day all,

I have numbers in N60 to N68 in O60 I have formula

=IF(N60="","",SUM(N60/9))

In N61 I want =IF(N60="","",SUM(N60/8))
IN N62 I want =IF(N60="","",SUM(N60/7))

Etc So basically I want it to minus the last number by 1 each time.. is
there an easy way for this?

Thanks

(I know I can do it manually..... But I would like to know for future
reference for a larger scale)

Thanks again
 
Back
Top