create a discount function in excel

[number]

hi!

I would like to create a series of discount functions in excel based on a certain product. For example, I am selling 10 brands and each of these brands has a different discount.
Say that I prepare an economical offer in excel, I'd like a function that as soon as I digit the name of that certain brand, the cost of that item, it gives me at once the rate of discount I have for that specific brand. Does this makes sense?
Say i am selling a sony camcorder, I know that with sony I have 50% of discount, I would like that when I write any number (the cost of the item) under the name sony (which excel should recognize) then it would apply at once a discount.
I know it's quite complicated but I hope someone wll help me thanks!!

[Toppers]

Is the discount by brand not product i.e. do all ALL Sony products havr (from
your example) a 50% discount?

"number" wrote:

>
> hi!
>
> I would like to create a series of discount functions in excel based on
> a certain product. For example, I am selling 10 brands and each of these
> brands has a different discount.
> Say that I prepare an economical offer in excel, I'd like a function
> that as soon as I digit the name of that certain brand, the cost of
> that item, it gives me at once the rate of discount I have for that
> specific brand. Does this makes sense?
> Say i am selling a sony camcorder, I know that with sony I have 50% of
> discount, I would like that when I write any number (the cost of the
> item) under the name sony (which excel should recognize) then it would
> apply at once a discount.
> I know it's quite complicated but I hope someone wll help me thanks!!
>
>
> --
> number
>
>
> ------------------------------------------------------------------------
> number's Profile: http://www.excelforum.com/member.php...o&userid=24949
> View this thread: http://www.excelforum.com/showthread...hreadid=384832
>
>

[Tushar Mehta]

Put the name of the product/brand togethe with the discount in a table,
then use the VLOOKUP function. For more check XL help for that
function.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>,
[email protected] says...
>
> hi!
>
> I would like to create a series of discount functions in excel based on
> a certain product. For example, I am selling 10 brands and each of these
> brands has a different discount.
> Say that I prepare an economical offer in excel, I'd like a function
> that as soon as I digit the name of that certain brand, the cost of
> that item, it gives me at once the rate of discount I have for that
> specific brand. Does this makes sense?
> Say i am selling a sony camcorder, I know that with sony I have 50% of
> discount, I would like that when I write any number (the cost of the
> item) under the name sony (which excel should recognize) then it would
> apply at once a discount.
> I know it's quite complicated but I hope someone wll help me thanks!!
>
>
> --
> number
>
>
> ------------------------------------------------------------------------
> number's Profile: http://www.excelforum.com/member.php...o&userid=24949
> View this thread: http://www.excelforum.com/showthread...hreadid=384832
>
>

[number]

yes, all the sony products have the same discount.

I have a price list with item name, code, price and discount.

I need to do an economical offer (in another sheet of course) and I would like that when I type a certain code article, it would give me its price and its discount, based on the other separate excel scheet.
From a new sheet, I would like to assign a price and a discount to a given name, based on a list located in another sheet.
How can I do this?
Thank you very much

[number]

Sorry guys, I don't really succeed to understand how to apply the VLOOKUP in what I want to do:

I have a price list with item name, code, price and discount.

I need to do an economical offer IN A SEPARATE SHEET and I would like that when I type a certain code article, it would give me its price and its discount, based on the other separate excel sheet.
As far as I am seeing, VLOOKUP cannot connect different sheets can it?

Do I have to use the VBS functions?


I don't want to use access, cause I prepare the economical offers in excel, so rather than going to look for the price and discount of a certain article in other excel files, I want to create queries and assignations and connect databases in excel. I know it is possible to do it, I just need to find out how.
I know it's a quite difficult operation, anyway,
Thank you very much

[Tushar Mehta]

I don't know what you tried with VLOOKUP because it is a simple
application of that function.

Suppose your brand/product name is in column A and the discount % is in
col. B starting with row 2 and going to row 4. Suppose the value you
want to look up is in E2. Then, the formula you want is
=VLOOKUP(E2,A2:B4,2,FALSE)
Adjust the range references to match your own data.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>,
[email protected] says...
>
> Sorry guys, I don't really succeed to understand how to apply the
> VLOOKUP in what I want to do:
>
> I have a price list with item name, code, price and discount.
>
> I need to do an economical offer IN A SEPARATE SHEET and I would like
> that when I type a certain code article, it would give me its price and
> its discount, based on the other separate excel sheet.
> As far as I am seeing, VLOOKUP cannot connect different sheets can it?
>
> Do I have to use the VBS functions?
>
>
> I don't want to use access, cause I prepare the economical offers in
> excel, so rather than going to look for the price and discount of a
> certain article in other excel files, I want to create queries and
> assignations and connect databases in excel. I know it is possible to
> do it, I just need to find out how.
> I know it's a quite difficult operation, anyway,
> Thank you very much
>
>
> --
> number
>
>
> ------------------------------------------------------------------------
> number's Profile: http://www.excelforum.com/member.php...o&userid=24949
> View this thread: http://www.excelforum.com/showthread...hreadid=384832
>
>