if i have 2 values, say 0 to 100, and want to spead them over 10 cells. What
formula can be uses? I know its possible but just don't know how.
thanks, Andrew
if i have 2 values, say 0 to 100, and want to spead them over 10 cells. What
formula can be uses? I know its possible but just don't know how.
thanks, Andrew
Type 0 in A1 and 100 in A10, then highlight A1:A10 and do Edit > Fill >
Series > check the TREND box and > OK
Vaya con Dios,
Chuck, CABGx3
"andrew1987" wrote:
> if i have 2 values, say 0 to 100, and want to spead them over 10 cells. What
> formula can be uses? I know its possible but just don't know how.
>
> thanks, Andrew
something like 0 in A1, then in A2 put in
=(100-0)/10+A1
where 10 represents the number of divisions
then drag fill down the column.
Adjust the approach to suite your specific needs.
--
Regards,
Tom Ogilvy
"andrew1987" <[email protected]> wrote in message
news:[email protected]...
> if i have 2 values, say 0 to 100, and want to spead them over 10 cells.
What
> formula can be uses? I know its possible but just don't know how.
>
> thanks, Andrew
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks