Thread: What is an Excel function that will calculate rebates?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Middleton Mike Middleton is offline
external usenet poster
  
Posts: 762
Default What is an Excel function that will calculate rebates?
NandC -

The usual approaches would use either nested IF functions (maximum of seven
in pre-2007 Excel) or a VLOOKUP function.

Specifics depend on the data for your "tiered rebate structure" and the
method you use to the "calculate the value."

- Mike
http://www.mikemiddleton.com

"NandC" wrote in message
...
Using a tiered rebate structure I want to calculate the value of a rebate
using a formula that determines the proper payout level.


Reply With QuoteReply With Quote