To rebate or not to rebate

[jwbeaty]

I am working a a spread sheet that works off list pricing at the top of the sheet I have a cell with that you input a discount in and the a column that calculates the sales price based upon the discount. how ever there are several items in the list that are not rebatable. There is a coulmn that is title rebatable Y/N. Can I adjust my current formula to look at that column and then assign a spacific rebate amount no mater what the inputed discount is?

I have attched a sample of my spread sheet

[ConneXionLost]

Your spreadsheet does not show a "Specific rebate amount" other than the discount percent; however, try this:

Please Login or Register  to view this content.

in cell H3, and autofill down.

Cheers,