software

Hey all

I've searched in the group history and haven't found the exact answer
for my problem.

I have an array of cells, each cell is calculated from the previous
one(s) - but not always in the same way (it's not always the same
formula)

from each cell's VALUE i want to substract 1 and then multiply by 100I tried the special paste feature, but it's problematic, since it
changes the value of the cell, and the next cell's value is changed
(here's an example)

A1 A2 A3
1.2 1.4 1.2

A1: 1.2
A2: = A1 0.2
A3: = A2-A1 1

Here are the desired results:
A1 A2 A3
20 40 20

Now, when applying that special paste, i will get unwanted results:
A1: 20 (as expected)
A2: 1920 ((20 0.2)-1)*100
A3: 190000

I hope I explained myself clearly.

Is this possible?You're on the right track with the paste special subtract and multiple.
Treat that as steps 2 and 3.

Step 1 as follows:
Copy the cells. Paste Special gt; Values

--
Rob van Gelder - www.vangelder.co.nz/quot;Zhekkaquot; gt; wrote in message oups.com...
gt; Hey all
gt;
gt; I've searched in the group history and haven't found the exact answer
gt; for my problem.
gt;
gt; I have an array of cells, each cell is calculated from the previous
gt; one(s) - but not always in the same way (it's not always the same
gt; formula)
gt;
gt; from each cell's VALUE i want to substract 1 and then multiply by 100
gt;
gt;
gt; I tried the special paste feature, but it's problematic, since it
gt; changes the value of the cell, and the next cell's value is changed
gt; (here's an example)
gt;
gt; A1 A2 A3
gt; 1.2 1.4 1.2
gt;
gt; A1: 1.2
gt; A2: = A1 0.2
gt; A3: = A2-A1 1
gt;
gt; Here are the desired results:
gt; A1 A2 A3
gt; 20 40 20
gt;
gt; Now, when applying that special paste, i will get unwanted results:
gt; A1: 20 (as expected)
gt; A2: 1920 ((20 0.2)-1)*100
gt; A3: 190000
gt;
gt; I hope I explained myself clearly.
gt;
gt; Is this possible?
gt;
No... it doesn't work You have to maintain the multiplier, so you probably need helper columns

B1: =(A1-1)*100
B2: =((B1 0.2)-1)*100
B3: =((((B1 0.2-1)*100)-(A1-1)*100 1)-1)*100--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Zhekkaquot; gt; wrote in message oups.com...
gt; No... it doesn't work
gt;
So, you're saying there's no other way rather than using new
columns/rows

(This will be problematic, since I already have a chart out of those
values.....)

Bob Phillips wrote:
gt; You have to maintain the multiplier, so you probably need helper columns
gt;
gt; B1: =(A1-1)*100
gt; B2: =((B1 0.2)-1)*100
gt; B3: =((((B1 0.2-1)*100)-(A1-1)*100 1)-1)*100
gt;
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Zhekkaquot; gt; wrote in message
gt; oups.com...
gt; gt; No... it doesn't work
gt; gt;There may be, but I cannot see it I am afraid.

Bob

quot;Zhekkaquot; gt; wrote in message oups.com...
gt; So, you're saying there's no other way rather than using new
gt; columns/rows
gt;
gt; (This will be problematic, since I already have a chart out of those
gt; values.....)
gt;
gt; Bob Phillips wrote:
gt; gt; You have to maintain the multiplier, so you probably need helper columns
gt; gt;
gt; gt; B1: =(A1-1)*100
gt; gt; B2: =((B1 0.2)-1)*100
gt; gt; B3: =((((B1 0.2-1)*100)-(A1-1)*100 1)-1)*100
gt; gt;
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;Zhekkaquot; gt; wrote in message
gt; gt; oups.com...
gt; gt; gt; No... it doesn't work
gt; gt; gt;
gt;