One method which allows for further additions of numbers and multipliers.

=LOOKUP(B3,{6,7,8},{6.6,7.2,7.8})*B6


Gord Dibben MS Excel MVP

On Sun, 25 Jan 2009 17:05:01 -0800, kitcatrn
wrote:

What formula do i use if
b3 = 6 then b8 equals b6 x 6.60
b3 = 7 then b8 equals b6 x 7.20
b3 = 8 then b8 eguals b6 x 7.80
I acn't figure it out!!!
Thanks
Kitcatrn