Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I. Create and Excel Function a.) Create an Excel function to calculate the following (spreadsheet tab Your Function): F = Ser+g-y)T To use the programming

image text in transcribedimage text in transcribed

I. Create and Excel Function a.) Create an Excel function to calculate the following (spreadsheet tab "Your Function"): F = Ser+g-y)T To use the programming tools in Excel your version must have the "Analysis ToolPak" and "Analysis ToolPak - VBA" add-ins. This is found by clicking on "File" then "Options" then "Add-Ins." Click on the add-in you want and hit "OK." You must then go to the [File, Options) "Customize Ribbon" and make sure that the "Developer" box is checked in the right hand column with "Main Tabs" listed at top. I have provide two example functions (User Defined] "Addemup" and "Addandraise." To see the code, go to the Developer tab and click on the left most icon Visual Basic. Once open you will see two small windows to the left and a larger widow to the right. At the top left most window will be a listing of objects including the sheets for the Excel workbook you are in. If "Modulel" is not highlighted, click on it. The code for the functions will appear in the big window. Study the code. Note "variables" must be assigned a type like "integer" or real number ("double"). They can be defined in the "function" statement (which is where you put the various inputs) or in the code via a "dim" statement. The function is assigned the value by "function name=." Bc 2 Examples of functions 3 4 "Addemup 5 "Andraise 6 "Andraise 7 8 9 Your Function 10 8 125 1

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Risk Management And Financial Institution

Authors: John C. Hull

2nd Edition

0136102956, 9780136102953

More Books

Students also viewed these Finance questions