Dear All
I have a sets of Sales & Cashback by categories here :
Every 10,000 Sales reached will get 50 cashback
** Max cashback is 250
So i wish to get a formula to cover this exact cashback amount
Ex : 10,000 (Sales) = 50 (cashback).
But when the amount is in between 10,000 and 20,000, Ex : 12,500, the cashback amount should be falls under 50, not 62.50
Attached herewith sample file
Thank you in advance
Set up a small tabel showing amount/rate and use:
=IF(H2="","",LOOKUP(H2,$Q$2:$Q$7,$R$2:$R$7))
see file.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Cell I2 formula , drag down
Formula:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks