add some numbers using if condition

0
Number of Packages Actual Weight Charged Weight                   16 32 90                   2 32 50                                           Question is I have use condition on charged weight that if  charged weight is less than 100 then print "200", if charged weight is in between 100-200 then print "300",if charged weight is in between 200-300 then print "400" and so on I have to add consecutive 100 in each if weight is increased by 100
Answer
Discuss

Answers

0
Selected Answer

This formula would do what you ask.

=ROUNDUP(A2+100,-2)

To test, enter the real weight in A2.

Discuss
0

You can use a lookup table.  I named the lookup Range 'LuTable'.  Consult Excel Help for how to use vlookup  [    =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])    ]

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login