Question: on excel Create a sub-procedure that reads two values in from two cells (C8, C9) in a spreadsheet, and calculates the sum of the squared
Create a sub-procedure that reads two values in from two cells (C8, C9) in a spreadsheet, and calculates the sum of the squared values. Display the sum of the squared values in a separate spreadsheet cell (011). Use values of 20 and 30 for the two inputs. In another cell (C12) show the following results using an IF statement or other decision method: If the resulting value is 100, display "Less than 100 of the resulting value is 2 100 and 1000 display "Between 100 and 1000" If the resulting value is > 1000 display "Greater than 1000" The sub-procedure should operate from a button within the worksheet. Your worksheet should be tabeled Problem 2 and your code module should be named Problem2. Use headers in your worksheet to indicate input and output cells
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
