If some one could help me with the following I would appreciate it.

Here is what I am trying to do:

Cell B2 contains the numbers I through 8

Cell D2 contains a pre-calculated number (e.g. 53.012)

Cell F2 is the cell that I need an IF function or something similar – the function would be as follows

=IF(B2=1,D2*1.000)

=IF(B2=2,D2*1.00057)

=IF(B2=3,D2*1.00171)

=IF(B2=4,D2*1.002281)

=IF(B2=5,D2*1.003421)

=IF(B2=6,D2*1.003991)

=IF(B2=7,D2*1.004215)

=IF(B2=8,D2*1.004538)

Thanks for your help

Bill