owais
New Member
Hi Excel Gurus,
Ok i have this question
I am selling a medicine @ 200 $ per box and there is an offer buy 10 boxes and get 2 free!!
Customer takes 10 boxes and as an offer gets 2 boxes free,
But later he returns 1 Box , so how can i calculate the refund and how much in excel, so i can calculate dynamically if more than 2 pieces are returned or so on?
Ok i have this question
I am selling a medicine @ 200 $ per box and there is an offer buy 10 boxes and get 2 free!!
Customer takes 10 boxes and as an offer gets 2 boxes free,
But later he returns 1 Box , so how can i calculate the refund and how much in excel, so i can calculate dynamically if more than 2 pieces are returned or so on?
Last edited: