Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
apply arithmetic functions on special multiple cells
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 100 I 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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
apply arithmetic functions on special multiple cells
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 Values -- Rob van Gelder - http://www.vangelder.co.nz/ "Zhekka" wrote in message oups.com... 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 100 I 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
apply arithmetic functions on special multiple cells
No... it doesn't work :(
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
apply arithmetic functions on special multiple cells
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) "Zhekka" wrote in message oups.com... No... it doesn't work :( |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
apply arithmetic functions on special multiple cells
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: 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) "Zhekka" wrote in message oups.com... No... it doesn't work :( |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
apply arithmetic functions on special multiple cells
There may be, but I cannot see it I am afraid.
Bob "Zhekka" wrote in message oups.com... 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: 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) "Zhekka" wrote in message oups.com... No... it doesn't work :( |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Use functions when cells are merged | Excel Worksheet Functions | |||
Formula to delete blank cells across multiple columns? | Excel Worksheet Functions | |||
How can I have excel search and add multiple cells to find a targe | Excel Discussion (Misc queries) | |||
How do I apply a combo box to multiple cells in Excel so that it . | Excel Discussion (Misc queries) |