Question: Please help I just need to know how to write the formula: just need to know how to write the formula by using the 'term'

Please help I just need to know how to write the formula:

just need to know how to write the formula by using the 'term' column. The formula of the LEFT function.

I wil really appreciate you help!!

Term of Loan: Presently, the term (Column F) has non-numeric values of "36 months" or "60 months." To transform the data into a new numeric variable named "Term of Loan," reference the cell with the -LEFTO Excel command and make the first two digits of the "term" variable. Transform the term, and name the new variable "Term Length." 13 14 15 16 17 18 19 Term of Leterm =LEFT 36 monti LEFT(text, [num_cha 36 month 36 month 60 month 36 month 60 month 36 month 60 month 60 month 60 month 36 month 36 month 36 month 36 month 36 month 36 month 36 month 36 month 36 month 60 month 36 month 36 month 36 month 36 month 36 month 36 month

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 Accounting Questions!

A pair of helical gears consist of a 20 teeth pinion meshing with a 100 teeth gear. The pinion rotates at 720 r.p.m. The normal pressure angle is 20 while the helix angle is 25. The face width is 40...

You are an owner of a floral delivery company, 1-800-BOUQUET. Currently, you are getting ready for Mothers Day and need to purchase bouquets of flowers which will be sold prior to the holiday. Due to...

Could you please take a look at these assignments, and give me a suggestion for your help. They are a little complicated and difficult, and I really need your help. Thank you Part.Page # 1 1 1 1...

v File Home Insert Draw Page Layout Formulas Data Review View Help Calibri - 11 === General Conditional Formatting BIU A A E $ %) 2 Format as Table Paste a. Ar Cell Styles Clipboard Font Alignment...

Please help with the excel calculations. I'm struggling with knowing what formula to use. Assume you are examining a financial instrument with a present value of $3,800 an investment term of 25 years...

Please help me with the following study guides. I have attached two files for your help. Thanks E24-16 Using responsibility reports to evaluate cost, revenue, and profit centers Learning Objective 3...

I only understood numbers 1 and 3, the others I need help with the functions to put in the cells. Vlookup and Hlookup is preferred for the functions as that is what the lab is on. Caption Emphasis...

please Help me!! needed it within 40 minutes! urgent Write a complete C++ program The program uses various types of structured data developed to calculate the profit of each item, the total amount of...

Assignment # 1 Scenario: You have just landed a job at Acme Hat Corporation. Your manager has asked you to develop a spreadsheet for all the temporary employees that need to be compensated on the...

JAVA: NEED HELP CREATING AN APPLET!!!!! home / study / engineering / computer science / computer science questions and answers / please help with part ii: part i: miles-per-gallon calculator write a...

Please only show me how to get the answers in excel. Any other solution won't help me, my test will be on excel so I have to know how do write the formula. Please only excel formula! Thank you. As...

Recorded here is the frequency distribution of the blood types of 100 persons who have volunteered to donate blood at a plasma center. Test the goodness of fit of the model, which assumes that the...

Eventide, Inc., has 10-year bonds with a total market value of $15,000,000 and 15-year bonds with a total market value of $55,000,000. The pretax costs are 11 percent and 4 percent, respectively. The...

In the balance sheet, inventory is listed immediately after accounts receivable because it is just one step further removed from conversion into cash than customer receivables. Group of answer...

Using Excel to prepare the statement of cash flows, indirect method The James Island Clothing Company began operations on July 1, 2018. The adjusted trial balance as of December 31, 2018 appears...