LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
help with setting up a spread sheet to track survey results Elnora Setting up and Configuration of Excel 1 May 28th 07 07:05 AM
In spread sheet the numbers entered as whole numbers become decim George A. Yorks Excel Worksheet Functions 3 January 28th 07 06:41 PM
Setting borders for two rows and all columns on spread sheet R OLEJAR Excel Worksheet Functions 0 February 1st 06 04:19 PM
I need help with setting up spread sheet in excel candy4lifersback Charts and Charting in Excel 1 June 3rd 05 07:49 PM
Setting up a spread sheet jean New Users to Excel 1 May 5th 05 07:54 PM


All times are GMT +1. The time now is 02:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"