formula for...

  • Thread starter Thread starter kitcatrn
  • Start date Start date
K

kitcatrn

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
 
One idea is to use a vlookup ..

In Sheet1, in A1:B1 down,
you have your reference table:

6 6.6
7 7.2
8 7.8
etc

Then in any other sheet,
if the lookup value is in B3,
place this in B8: =IF(B3="","",VLOOKUP(B3,Sheet1!A:B,2,0)*B6)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
 
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
 
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)
 
So no matter what number I put in there it will work? as long as 0.6
difference is right?
 
Thank you so much Rick this is awesome and saves so much time for me!!! Just
a little redneck trying to figure out an easier softer way!!! LOL
 
Yep... as long as the difference in the multipliers is 0.6 for every
increase of 1 in B3, that formula will work.
 
It is indeed very nice to use math instead of "IF" statements! (And should
be faster.)
For thouse of us who cannot remember the Operator Precedence and like
self-documenting formulas, I suggest:
=B6*(3+(0.6*B3))
 
Back
Top