Formula help

  • 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
 
First off, since you are not summing a range of values, you don't need the
Sum function... just do the division directly. Now, for your formula, put
this in O60 and copy down...

=IF(N60="","",N60/(18-ROW(A9)))
 
Back
Top