Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
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
Answers
0
Selected Answer
This formula would do what you ask.
=ROUNDUP(A2+100,-2)To test, enter the real weight in A2.
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]) ]