PDA

View Full Version : VB code



ami3
06-12-2008, 09:05 AM
Hi,
I am trying to write a code with the formula given below.

=AN3*(1-(0.025/1))^(1*r)

i want "r" value will decrease by 1 gradually with the decrease in column number.

It will be great if you can write a code for this formula in excel sheet.Thanks

mdmackillop
06-12-2008, 09:13 AM
=AN3*(1-(0.025/1))^COLUMN() or even =AN3*0.975^COLUMN()

RonMcK
06-12-2008, 09:20 AM
<deleted> (duplicated Malcolm's solution.