Answered step by step
Verified Expert Solution
Question
1 Approved Answer
VBA in Excel 1. Using the provided data, assign the people new salaries. Each person has a current salary and a performance rating. Higher performance
VBA in Excel 1. Using the provided data, assign the people new salaries. Each person has a current salary and a performance rating. Higher performance ratings give better raises. Rating Raise Percentage 5 .1 4 .08 3 .06 2 .04 1 .02 To calculate a new salary, multiply the old salary by (1+raise percentage). A 1000 dollar salary with a 5 rating would be 1000*(1+.1) or 1100. The result should show up in the New Salary Column. This should run on the Raises sheet and run from a button on that sheet labeled "Calculate Raises 2. Create a function that will convert a measured volume into another unit of measure. It should take 2 inputs, a volume and a unit of measurement. It should return the volume in the opposite units. For instance, 100 ml should change to about 3.5 oz and 10 oz should change to about 296 ml. Your output should include both the volume and new units, in a single column. Use the function in the "converted units" column of the "Volconversion" sheet. You will need to look up the conversion factor (google mi to oz). Check your output vs a reliable source. No need to round, Person Salary Perfomance Rating New salary 96000 Scott 5 Sara 46000 4 Denice 115000 3 Iris 73000 2 39000 1 75000 5 120000 4 Lillian Ning Jose Young Jin Tiange Lars 55000 65000 89000 1 B ca 1 Volume Unit of Measure Converted units 2 50 ml 3 16 OZ 4 12 Oz 5 500 ml 5 6 1.5 OZ 1000 ml 335 ml 00
VBA in Excel
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started