Thread: formula for...
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kitcatrn kitcatrn is offline
external usenet poster
 
Posts: 3
Default formula for...

So no matter what number I put in there it will work? as long as 0.6
difference is right?
--
Kitcatrn


"Rick Rothstein" wrote:

If your multipliers are accurate and if the 0.6 difference between
multipliers remains constant for other possible values for B3 (if any)...

=B6*(3+0.6*B3)

--
Rick (MVP - Excel)


"kitcatrn" wrote in message
...
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