Hi
I hope you can help me. I have weight bands to calculate for delivery purposes and could do with your help.
Less than 20 Kg the charge is £6.00
Over 20 Kg and under 100 Kg £6.00 plus £00.20 per Kg
Over 100 Kg £6.00 plus £00.22 per Kg.
All my figures are in column A
Any help with a formula would be appreciated.
Last edited by Jordan; 09-27-2010 at 12:54 PM. Reason: Thank so very much
=if(a1<=20,6,if(and(a1>20,a1<=100),6+(a1-20)*0.2,6+(a1-20)*0.22))
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
You could use a lookup table. See attached example.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Thank you so very much
Another variation:
=6+(A1-20)*LOOKUP(A1,{0,20,21,101},{0,0,0.2,0.22})
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks