Prev: Consecutive numbering
Next: Think I need a MAX / MIN formula here (help needed)
From: David on 31 Mar 2010 20:38

Excel 2007
How do I make a range of cells values from 100 to 500 with increments of 5,
i.e., 100+5...(100 105 110 115 120...500)
From: Ashish Mathur on 31 Mar 2010 21:26
Hi,

Enter 100 in cell A5. In cell A6, type =A5+5 and copy down

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"David" <David(a)discussions.microsoft.com> wrote in message
news:AB57D950-ECB3-4FAD-8916-B4E791CB54B2(a)microsoft.com...
>
> Excel 2007
> How do I make a range of cells values from 100 to 500 with increments of
> 5,
> i.e., 100+5...(100 105 110 115 120...500)

 | 
Pages: 1
Prev: Consecutive numbering
Next: Think I need a MAX / MIN formula here (help needed)