vlookup and if function

Microsoft Excel 2003 (full product)
May 26, 2010 at 20:38:09
Specs: Windows XP
I need to weigh the parcel and base on the weight to calculate the delivery fee. Can excel have a function or are there any ways to do so? Are there ways like whenever I input the weight of the parcel , it will automatically jump into quantity column which i already made.(sample as below)

weighted parcel( i have to enter): 25

Grams Quantity Tracking total amount$$
10-20 1
21-50
51-60

THanksss


See More: vlookup and if function

Report •


#1
May 27, 2010 at 07:19:11
Tip:

If you use the pre tags found above the comments box, you can line up your example data to make it easier for us to read.

I'm not sure if this is what your table should look like....

Grams   Quantity   Tracking   total amount$$ 
10         20          1
21         50
51         60

re: Are there ways like whenever I input the weight of the parcel , it will automatically jump into quantity column which i already made

What do you mean by "jump into quantity column"? Do you mean you want to return a value from that column?

If that's the case, using your example of 25, which value should be returned?


Report •

#2
May 27, 2010 at 18:21:41
Thank you Derbydad03.

I create a table like:

weighted parcel: (place I input data as grams)


Grams total Qty Registered mail Qty total amount$$
10
20
50-80

I would like to do something like:

case 1 > if i enter the weight of the parcel eg 21g, the table
below could notice that is above 20g and thus place
to quantity column in 50g as "1", if not return to 0

case 2> if i have 2 parcels that is with 21g, that 2 parcels can
jump into the quantity column in 50 g as "2" if not return to 0.

case 3> if I have 2 parcels with the weight within the range of
50-80g, say 55g and 78g but the difference is one is
registered and one is non-registered.
The outcome should be :in Gram column 50-80g
2 parcels in total qty
1 parcel in registered

Grams total Qty Registered mail (qty) total amount$$
10
20
50-80

thzzzzzzzzzzzzzz


Report •

Related Solutions


Ask Question