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

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

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

kitcatrn;198152 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


--
The Code Cage Team

Regards,
The Code Cage Team
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=54568

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

One other way...

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

= = =
Dana DeLouis


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

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

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

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

--
Rick (MVP - Excel)


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

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

"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