Hi All,
If I have a column with weights in and want to automate the postage cost how would I do this please? So Item is less than 100g or 0.100kg postage is £1.50 between 0.101 > 1.000 kg is £3.00, 1.001> 2.000 kg is £4.00. I'm sure this is an easy one for you guys and thanks in anticipation.
kind regards
Jason
=LOOKUP(A1,{0,0.101,1.001,2.001},{1.5,3,4,4}) or =LOOKUP(A1,{0,0.101,1.001},{1.5,3,4})
what above if it is more than 2 Kgs
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
I'm thinking this seems easiest provided you don't have anything less than 0.100kg to also weigh with a different rate again...
assuming your weights are in col A
=IF(A1<1,A1*1.5,IF(A1<2,A1*3,A1*4))
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
May be this
Formula:
=IF(A1>1,4,IF(A1>0.1,3,1.5))
☚ Click ★ just below left if it helps, Boo?ath?
OK so I'm trying this method and I may be doing it wrong but I think it's almost but not quite right. Please correct me if I'm wrong. (E1) is the weight so assume weight is less than 100g and cost is £1.50 then =IF(E1>0.1,1.5) Is that correct? if so I'll move to the next levelOriginally Posted by boopathiraja
May be this
Formula:=IF(A1>1,4,IF(A1>0.1,3,1.5))
Oh, i see my erroryou didn't want the weight multiplied by the price, just if it fell within those parameters give the price.
then i'd recommend boopathiraja's as i would have come up with about the same thing.
Thanks all. I'll give it a try and let you know how I get on.
kind regards
you can always use mine, here is how i would have changed it.
=IF(A1<1,1.5,IF(A1<2,3,4))
Thanx but I think still not right (or am I wrong?)
=IF (E1<0.1,1.5) E1 being the weight
Like this
Check if >1,(that is anything above one) result, 4
fail then
Check if >0.1(that is 0.1 to 1), result, 3
fail then
Check if >0(that is 0-0.999), result, 1.5
=IF(E1>1,4,IF(E1>0.1,3,IF(E1>0,1.5)))
Can be constructed in vise versa also
=LOOKUP(E1,{0,0.101,1.001,2.001},{1.5,3,4,4}) or =LOOKUP(E1,{0,0.101,1.001},{1.5,3,4})
TRY THIS
Hi nflsales I would but honestly I don't understand it. When I paste that in to the cell it says there is a problem. I'm a serious novice..
I'm just trying to get my head round these so may be back to ask to elaborate please. as a matter of interest 2.001 kg > 5.000kg is £5.00 and over 5.001 kg is £7.00 in case any one would like to update their formulae
=lookup(e1,{0,0.101,1.001,2.001,5.001},{1.5,3,4,5,7})
try this
Hi nflsales. I think that's done it thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks