- An analysis of a group of weight measurements involves converting a weight value into an integer category number that is determined as follows:
Category Weight (pounds)
1 weight<=50.0
2 50
3 125.0
4 200.0
Write a VBA program that takes an input weight and puts the correct value (1,2,3, or 4) into CATEGR based on thevalue of WEIGHT. Note that CATEGR is an integer, while the weight should be a real variable. The program should finally output the input weight and the category that it fell into