hi,
i am having a problem making a formula for this little problem i have. the question is about costs regarding the weight of packages sent by sea. if the weights are listed down column A incrementing by 20g to 200g , incrementing by 50g to 1000g , incrementing by 250g to 5000g how can i make 1 formula which will fill in the prices of the packages in col B IF
-it costs $5 for less than 250
-upto 2kg: add $3 for each 250g or part thereof
-more than 2kg: $3 for each additional 500g or part thereof
for eg it would cost $8 for anything between 250g and 500g but it will cost $11 for anything between 500g and 750g.
please help, ive been trying to do this for soo long but still cant work it out. nested if statements are way to complicated for this question
thanx jason
i am having a problem making a formula for this little problem i have. the question is about costs regarding the weight of packages sent by sea. if the weights are listed down column A incrementing by 20g to 200g , incrementing by 50g to 1000g , incrementing by 250g to 5000g how can i make 1 formula which will fill in the prices of the packages in col B IF
-it costs $5 for less than 250
-upto 2kg: add $3 for each 250g or part thereof
-more than 2kg: $3 for each additional 500g or part thereof
for eg it would cost $8 for anything between 250g and 500g but it will cost $11 for anything between 500g and 750g.
please help, ive been trying to do this for soo long but still cant work it out. nested if statements are way to complicated for this question
thanx jason