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

 on excel Create a sub-procedure that reads two values in from
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 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!