I have a list of advertisers, the size ad they want, if they want color, if
they want special placement, if they get a discount. These have simply been
listed as yes/No or a number to represent the size ad requested.

I would like to code each of these basic values like price for each ad size,
price for color, etc. Then after I fill lin the the info from the advertising
contract, have Excel fill in the colums that tell me the cost for each of the
items they requested. Then apply discounts and give a final total for billing.

I rpinted an Office Online things called Creating Custom Functions and one
called Dynamic searching using VLOOKUP, MATCH, and INDEX. Should these be
helpful.

I am just not sure what to call what I need.

--
Kasey

Sounds more like you need a project done than a question.

--
Don Guillett
SalesAid Software

"Kasey" <123@456. com wrote in message
...
I have a list of advertisers, the size ad they want, if they want color, if
they want special placement, if they get a discount. These have simply
been
listed as yes/No or a number to represent the size ad requested.

I would like to code each of these basic values like price for each ad
size,
price for color, etc. Then after I fill lin the the info from the
advertising
contract, have Excel fill in the colums that tell me the cost for each of
the
items they requested. Then apply discounts and give a final total for
billing.

I rpinted an Office Online things called Creating Custom Functions and one
called Dynamic searching using VLOOKUP, MATCH, and INDEX. Should these be
helpful.

I am just not sure what to call what I need.

--
Kasey

I gave details because I don't know what to call the kind of function/formula
I need. I'm not aksing for someone to do it for me. I just need some ideas of
what to look at. Thanks anyway.
--
Kasey


"Don Guillett" wrote:

Sounds more like you need a project done than a question.

--
Don Guillett
SalesAid Software

"Kasey" <123@456. com wrote in message
...
I have a list of advertisers, the size ad they want, if they want color, if
they want special placement, if they get a discount. These have simply
been
listed as yes/No or a number to represent the size ad requested.

I would like to code each of these basic values like price for each ad
size,
price for color, etc. Then after I fill lin the the info from the
advertising
contract, have Excel fill in the colums that tell me the cost for each of
the
items they requested. Then apply discounts and give a final total for
billing.

I rpinted an Office Online things called Creating Custom Functions and one
called Dynamic searching using VLOOKUP, MATCH, and INDEX. Should these be
helpful.

I am just not sure what to call what I need.

--
Kasey

The functions that you will need depend largely on your method for
determining additional costs. If e.g. color adds a certain amount of $$
to the total cost then you need maybe SUMPRODUCT, assuming that you
have the fixed costs in a header row and then, 1/0 values in the
adverstiser row.

If they are percentages of a basic it might be similar solution.
I doubt you would have to resort to more than VLOOKUP as an alternative
to IF. But, unless the method of computing the costs is given we cannot
help you with somethig more precise.

HTH
Kostis Vezerides

Kasey wrote:
I gave details because I don't know what to call the kind of function/formula
I need. I'm not aksing for someone to do it for me. I just need some ideas of
what to look at. Thanks anyway.
--
Kasey


"Don Guillett" wrote:

Sounds more like you need a project done than a question.

--
Don Guillett
SalesAid Software

"Kasey" <123@456. com wrote in message
...
I have a list of advertisers, the size ad they want, if they want color, if
they want special placement, if they get a discount. These have simply
been
listed as yes/No or a number to represent the size ad requested.

I would like to code each of these basic values like price for each ad
size,
price for color, etc. Then after I fill lin the the info from the
advertising
contract, have Excel fill in the colums that tell me the cost for each of
the
items they requested. Then apply discounts and give a final total for
billing.

I rpinted an Office Online things called Creating Custom Functions and one
called Dynamic searching using VLOOKUP, MATCH, and INDEX. Should these be
helpful.

I am just not sure what to call what I need.

--
Kasey

Thank you, that gives me more of a direction. The prices are all set. I could
calcualte the discounts at the end. Getting the intial costs/prices is the
biggest part I think.

I appreciate the help.
--
Kasey


"vezerid" wrote:

The functions that you will need depend largely on your method for
determining additional costs. If e.g. color adds a certain amount of $$
to the total cost then you need maybe SUMPRODUCT, assuming that you
have the fixed costs in a header row and then, 1/0 values in the
adverstiser row.

If they are percentages of a basic it might be similar solution.
I doubt you would have to resort to more than VLOOKUP as an alternative
to IF. But, unless the method of computing the costs is given we cannot
help you with somethig more precise.

HTH
Kostis Vezerides

Kasey wrote:
I gave details because I don't know what to call the kind of function/formula
I need. I'm not aksing for someone to do it for me. I just need some ideas of
what to look at. Thanks anyway.
--
Kasey


"Don Guillett" wrote:

Sounds more like you need a project done than a question.

--
Don Guillett
SalesAid Software

"Kasey" <123@456. com wrote in message
...
I have a list of advertisers, the size ad they want, if they want color, if
they want special placement, if they get a discount. These have simply
been
listed as yes/No or a number to represent the size ad requested.

I would like to code each of these basic values like price for each ad
size,
price for color, etc. Then after I fill lin the the info from the
advertising
contract, have Excel fill in the colums that tell me the cost for each of
the
items they requested. Then apply discounts and give a final total for
billing.

I rpinted an Office Online things called Creating Custom Functions and one
called Dynamic searching using VLOOKUP, MATCH, and INDEX. Should these be
helpful.

I am just not sure what to call what I need.

--
Kasey