multiple if functions-- Help please

[kikigee]

I have a spread sheet with multiple price classes for products..
I don't quite know how to word what exactly I'm trying to do..
Here goes ...
I need to make a fuction that;
if I have a price="price class" then price x "price discount" then for all the price classes.
I have multiple price classes.
so..
=IF(K33=R33,K33*M10)

http://i47.tinypic.com/1g4r3r.jpg

 

[GRTorres]

Hi kikigee,

I am going to take a whack at this and determine what you are saying:

If price class can be found in the price class table, then look up the corresponding discount and multiply that by the price.

If this is the case, then you can use the following formula:

=IF(ISNUMBER(MATCH(R33, $L$8:$L$14, 0)), VLOOKUP(R33, $L$8:$M$14, 2, FALSE)*K33)

Let me know if this does not work, paste this in cell U33, if it goes in order that is.

 

[kikigee]

Hi GRTorres!!

I think it could have worked!! I'm just playing around with it now to see what's going on, but from what I have so far it did workk!!

Thank you sooo much!!