Forum Discussion
whats is an excel calculation for: for every two items they get $5 off?
How do I create an excel function if I want to calculate for every second item they purchase they get $5 off So I input the number of quantity a customer purchased, and it will calculator for me the...
Could be like
=20*A1-INT(A1/2)*5
if A1 is number of purchases
Awesome. Thanks!
