ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   distributing numbers (https://www.excelbanter.com/excel-discussion-misc-queries/22188-distributing-numbers.html)

Neil

distributing numbers
 
Hello,

I need some help coming up with an equation, or finding an existing one that
would work.

example:
123
-
-
789

I would like to find 2 numbers (-) that are evenly distributed between the
numbers 123 and 789.

thanks!

Barb R.

If

A1=123
A2=789

A3=A1+(A2-A1)/3
A4=A1+2*(A2-A1)/3

"Neil" wrote:

Hello,

I need some help coming up with an equation, or finding an existing one that
would work.

example:
123
-
-
789

I would like to find 2 numbers (-) that are evenly distributed between the
numbers 123 and 789.

thanks!



All times are GMT +1. The time now is 10:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com