formula for...

[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

 

[Max]

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

 

[Gord Dibben]

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

 

[The Code Cage Team]

Use a nested IF statement like this:
=IF(B6=6,B6*6.6,IF(B6=7,B6*7.2,IF(B6=8,B6*7.8,0)))

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

--
The Code Cage Team

Regards,
The Code Cage Team
'The Code Cage' (http://www.thecodecage.com)

 

[Rick Rothstein]

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)

 

[Dana DeLouis]

One other way...

=IF(OR(B3={6,7,8}),B6*(3+0.6*B3),"x")

= = =
Dana DeLouis

 

[kitcatrn]

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

 

[kitcatrn]

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

 

[Rick Rothstein]

Yep... as long as the difference in the multipliers is 0.6 for every
increase of 1 in B3, that formula will work.

 

[KIM W]

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))