LinkBack URL
About LinkBacks
Try
=IF(A1<11,0,IF(A1<=20,(A1-10)*0.25,(A1-20)*0.5+2.5))
A1=Quantity
so A1=25
=10*0.25+5*0.5 is 2.5+5*0.5
Try
=IF(A1<11,0,IF(A1<=20,(A1-10)*0.25,(A1-20)*0.5+2.5))
A1=Quantity
so A1=25
=10*0.25+5*0.5 is 2.5+5*0.5
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks