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 :(
|