Hi All,
Hope you are doing well!.. I am trying to determine the price for the input table which has the industry and the average monthly number of transactions..The reference table1 classifies the pricing tiers based on the number of transactions...The general rule is tier A is priced at 30 and tier B is priced at 95% of price of Tier A and Tier C is priced at 95% of tier B and so on..Can you please help me with this ..Attached the sample excel table with the input and the output tables..
Thanks,
Arun
Bookmarks