We provide customers a range of 4+tems, with quantities against each one. the charge is £33.00 per 20 items & then £1.10 per item over and above this price.
Item 1 = 13 Item 2 = 14 Item 3 = 6 Item 4 = 8
Total items quantity = 41 items
21 @ £1.10 = £23.10 + £33.00 = £56.10
I've tried doing it by totalling the items and then minusing 20, but if there are less than 20 items, this doesn't work, as it gives a negative.
Help?
Last edited by kayjohnson; 07-07-2008 at 10:20 AM.
Like this
Alter your cell ref to suit
Please Login or Register to view this content.
Ed
_____________________________
Always learning, but never enough!
_____________________________
I don't think you want to use modulo.
=33 + 1.1 * MAX(0, C14-20)
Rylo
Ooops, I think you're right!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks