ExcelBanter - Range of values

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Range of values (https://www.excelbanter.com/excel-worksheet-functions/260426-range-values.html)

David

Range of values

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)

Ashish Mathur[_2_]

Range of values

Hi,

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"David" wrote in message
...

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)

All times are GMT +1. The time now is 01:42 PM.