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