View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Zhekka
 
Posts: n/a
Default 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 :(