|
Don't know what to call the type of function I need
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 |
Don't know what to call the type of function I need
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 |
Don't know what to call the type of function I need
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 |
Don't know what to call the type of function I need
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 |
| All times are GMT +1. The time now is 08:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com