| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spread numbers by setting up a Min and Max
Hi,
If I want to spread the numbers between two cells, lets say A1 is the minimum of something and A5 is the maximum, what's the formula to do this? For example, if A1 is 10 (minimum) and A5 is 100,000 (maximum), by using such a formula, I will have like the following: A2= 100, A3= 1,000, A4= 10,000 Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Spread numbers by setting up a Min and Max
=A1*(A$5/A$1)^(1/(ROW(A$5)-ROW(A$1))) in A2, & copy down
-- David Biddulph "Turki755" wrote in message ... Hi, If I want to spread the numbers between two cells, lets say A1 is the minimum of something and A5 is the maximum, what's the formula to do this? For example, if A1 is 10 (minimum) and A5 is 100,000 (maximum), by using such a formula, I will have like the following: A2= 100, A3= 1,000, A4= 10,000 Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Spread numbers by setting up a Min and Max
In A2 enter:
=A1*10 and copy downward -- Gary''s Student - gsnu200908 "Turki755" wrote: Hi, If I want to spread the numbers between two cells, lets say A1 is the minimum of something and A5 is the maximum, what's the formula to do this? For example, if A1 is 10 (minimum) and A5 is 100,000 (maximum), by using such a formula, I will have like the following: A2= 100, A3= 1,000, A4= 10,000 Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with setting up a spread sheet to track survey results | Setting up and Configuration of Excel | |||
| In spread sheet the numbers entered as whole numbers become decim | Excel Worksheet Functions | |||
| Setting borders for two rows and all columns on spread sheet | Excel Worksheet Functions | |||
| I need help with setting up spread sheet in excel | Charts and Charting in Excel | |||
| Setting up a spread sheet | New Users to Excel | |||
Linear Mode
