rebate

I am trying to create a formula that distributes the data in Y1-Y20 (these are years) by month over the Rebate Start and End Date Range. The challenge is the data changes year to year. Can anyone help...

I need to calculate the Rebate % earned based on two criteria: sales volume & compliance ratio - the 3 columns I'm trying to complete are in red: Tier, Rebate % & Rebate Amount. Question: What is the rebate amount for customer 121761 for September? Sales Volume is over $100K and Compliance...

I have to look up on table a rebate to subtract from salesmen gross sales. For one salesman I have multiple customers buying same items but not all get same rebates. For example customer infiniti naples buys item 01011 with rebate of $5, but customer dodge naples buys item 01011 with rebate $4...

There is a CTR-CAR (Customer Transaction report / Customer accrual report) excel file that has a "CTR" Tab and a "CAR" tab. The CTR tab has a "Rebate No" column and often we have to pull a list of 10 or more rebate ID sections from the CAR report into a blank excel sheet to provide sufficient...

<tbody> A B D E Reference 1 Monthly Sales Rebate Target Rebate Target 2 1245000 1500000 500000 3 1000000 4 1500000 5 2000000 </tbody> Dear Members Greetings from Nigeria. First of all Thank you for having this Forum. This really helps me learn a lot. Please look...

Dear Friends, Working in a workbook where there are multiple if conditions: Sheet1 <colgroup><col style="WIDTH: 30px; FONT-WEIGHT: bold"><col style="WIDTH: 176px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 108px"><col style="WIDTH...

"work out an expression for rebates to be given to delegates accommodated in the overspill hotel and enter it into cell j63" after 500 guests have been booked in the remaining guests are to be placed in the overspill hotel and will recieve a rebate of £20 im really struggling with this so any...