Write one Microsoft excel formula that works for conditions below on cell C1 for any number: a) IF A1+B1<=4, return $20 b) IF A1+B1>4 but <=9, return $35 c) IF A1+b1>9 but <=14, return $50 d) And IF A1+B1>15, return

135,657 results

  1. basic excel

    Write one Microsoft excel formula that works for conditions below on cell C1 for any number: a) IF A1+B1<=4, return $20 b) IF A1+B1>4 but <=9, return $35 c) IF A1+b1>9 but <=14, return $50 d) And IF A1+B1>15, return $75
  2. Excel formula help

    Formula to multiply the number in cell 4k times standard deviation of the numbers in cell z2 through z10 I don't understand cell z2 through z10 I have never had excel (4kxz2xz10) Please write this correctly
  3. Excel Filtering

    Return 2005 Return 2006 Return 2007 I have a data table with returns for 3 different years. I want to use a filter that only includes records where the return is increasing each year(i.e.: 2005<2006<2007) I"m stuck please help.
  4. Excel help please

    How would I write a formula to multiply the number in cell z675 times the number in cell a1
  5. Excel computers

    How would you write a formula to multiply the number in cell k4 times the standard deviation of the number in cell z2 through z10
  6. Excel

    How would you write a formula to divide the number in the cell v45 by the number in cell b78
  7. Excel help

    How would I write a formula to multiply the number in cell k4 times the standard deviation of the numbers in cell z2 through z10
  8. computers

    Dear Sir, thanks very much for your the very detail instruction which I am still working on it. I need some help in using Microsoft Excel to format rational number in the form a/b( not in reduced form :eg. 3/6 but Excel will return value either in reduced form 1/2 or .5). What...
  9. Microsoft excel unit

    Determine the present value of a pension plan that will pay you 20 yearly payments of $7,000 each;the current rate of return in 7.5%
  10. math

    It is equally probable that stock A will have a +10% or -10% rate of return The only other possibility is that it will return 0%.The probability of 0% is twice that for a return of +10%. What is the expected return and Standard deviation of the return for stock A?
  11. Statistics

    According to a recent survey, 65% of all customers will return to the same grocery store. Suppose 11 customers are selected at random,what is the probability that A) exactly 5 will return? B) all 11 will return? C) at least 6 will return D) at least one will return E) how many...
  12. Statistics

    According to a recent survey, 65% of all customers will return to the same grocery store. Suppose 11 customers are selected at random,what is the probability that A) exactly 5 will return? B) all 11 will return? C) at least 6 will return D) at least one will return E) how many...
  13. Computers excel

    How would you write a formula to divide the quantity of cell c1 plus c 8 by the number in a 98
  14. microsoft 2013

    10. David has a small business and is working on an Excel worksheet to help manage his inventory. David realizes cell E14 has the wrong output. To check the problem, David should first select cell E14 and look at the _______ to check the formula. A. range B. Formula bar C. ...
  15. programming

    I had to create a c code that gets a number, returns how many digits it has,the digits sum, the digits product, to check if the digits sum is equal to product if yes return "1" else return 0, and in the end write a program the prints the first 20 numbers that the sum of their ...
  16. finance

    Here are data on $1,000 par value bonds issued by Microsoft, Ford, and Xerox at the end of 2008. Assume you are thinking about buying these bonds as of January 2009. Answer the following questions: a.) Calculate the values of the bonds if your required rates of return are as ...
  17. finance

    The expected return on the market is 12% and the risk free rate is 7%. The standard deviation of the return on the market is 15%. Ones investor creates a portfolio on the efficient frontier with an expected return of 10%. Another creates a portfolio on the efficient frontier ...
  18. Statistics

    According to a recent survey, 75% of all customers will return to the same grocery store. Suppose 8 customers are selected at random: A) What is the probability that exactly five of the customers will return? B) What is the profability that all 8 will return? C) What is the ...
  19. Finance

    One way to think about the required rate of return is: as the highest return a risk-averse investor wants from an investment. as the risk-free rate of return plus a risk premium. as the historical rate of return plus a risk premium. as a comparison between the expected and ...
  20. statistics

    {Exercise 3.55} Morningstar tracks the total return for a large number of mutual funds. The following table shows the total return and the number of funds for four categories of mutual funds (Morningstar Funds500, 2008). a. Using the number of funds as weights, compute the ...
  21. Computer (C)

    I need help with c programming, i need to fill in the code and I got these (need help with question 4), I run the grader and I only got question 1 right. grader code: gcc worksheet.c; ./a.out 0; if [ $? -eq 0 ] then echo 'Question 0 Correct'; else echo $? 'is not correct for ...
  22. MAth

    Over a four year period the value of a stock increased from $15 per share to $24.89. Determine the total return and annual return.State answers to the nearest 0.01%.Total Return: Annual Return:
  23. Probability

    There are three investment plans for your consideration. Each plan calls for an investment of $25,000 and the return will be one year later. Plan A will return $27,500. Plan B will return $27,000 or $28,000 with probabilities of 0.4 and 0.6, respectively. Plan C will return $...
  24. Finance

    9. The variable (A) in the utility formula represents the: a. investor’s return requirement. b. investor’s aversion to risk. c. certainty equivalent rate of the portfolio. d. preference for one unit of return per four units of risk.
  25. C#

    Write a two class application that has a one-dimensional array as a data member. The array stores temperatures for any given week. Provide constructors for instantiating the class and methods to return the highest temperature, lowest temperature, average temperature, and the ...
  26. programming c#

    how do I Write a two class application that has a one-dimensional array as a data member. The array stores temperatures for any given week. Provide constructors for instantiating the class and methods to return the highest temperature, lowest temperature, average temperature, ...
  27. General Math

    I am so confused can anyone help me understand which one is correct and why.... Beta is estimated as the slope of a regression line fit to pairs of periodic returns, (rx, ry), where: rx is the return for a market index such as the S&P 500 Index. rx is the return for the stock ...
  28. Probabability

    You are given monthly annualized total return data for two mutual funds, A and B. Using linear regression, develop a relationship which gives the annualized return of fund B as a function of the return of fund A. What is the coefficient of determination of this relationship? ...
  29. statistics

    One of nature's patterns connects the percent of adult birds in a colony that return from the previous year and the number of new adults that join the colony. Following are data for 13 colonies of sparrowhawks: Percent return 73 61 79 54 75 62 53 46 57 50 62 45 35 New adults 4...
  30. Stats Anyone?

    The first-year retention rate is the percentage of entering freshman at a given college who return to that same college for their sophomore year. Many colleges use the first-year retention rate as one measure of their quality. Suppose that the first-year retention rate at a ...
  31. General

    I do not know what subject to put this uh ok how do I put this into one cell into microsoft excell into one cell - .49 m when i put "-" it thinks I'm entering a formula which is not what I'm tyring to do i want negetive .49 m m being meters into one cell and do not know how to
  32. algebra 1

    NEED HELP!!Hi, I have been trying to figure this one math problem for awhile and I am stuck. I believe the answer is between A or B. Skip is practicing tennis serves against a wall. The distance between Skip and the tennis ball, in feet, at any time T, measured in seconds, is ...
  33. Fat gram calculator

    Design a program that asks the user for the number of fat grams and calories in a food item. Validate the input as follows. Make sure the number of fat grams and calories are not less than 0. According to nutritional formulas, the number of calories cannot exceed fat grams * 9...
  34. Finance

    IBM's common stock has a beta of 0.85. If the expected risk-free return is 4.5% and the market risk premium is 7%. a) Calculate IBM’s required rate of return (10pts) b) Assume IBM’s actual realized return is 15%. Calculate its abnormal return (i.e. alpha). (5pts)
  35. microsoft exel help

    Suppose that cell B2 contains the budgeted amount and cell C2 contains the actual amount. Write the formula (including the IF conditions) that would insert the word under if the actual amount was less than the budgeted amount and insert the word over if the actual amount was ...
  36. Finance

    Calculate the return and standard deviation for the following stock, in an economy with five possible states. If a Boom (Probability=25%) economy occurs, then the expected return is 30%. If a Good (Probability=25%) economy occurs, then the expected return is 15%. If a Normal (...
  37. Brian

    A stock has an expected return of 15 percent, its beta is 0.4, and the risk-free rate is 6.75 percent. The expected return on the market must be ?percent. This sample give the ERM as 0.2738 but dosent give the formula. What would the formula be?
  38. Microsoft Excel 2007

    I think that I already typed this in, but forgot to click on the submit question button. Could you please provide me with some reference material as to how vertical lookup works? All of the formula fields cause me to become clueless! What are lookup values, table arrays, ...
  39. C++

    Write a statement that passes the value 4 to the function below and assign it's return value to the variable result. Thank You. int cube(int num) { return num*num*num; }
  40. Technical writing

    Access the user manual for any one of the following programs or applications: • Microsoft® Access • Microsoft® PowerPoint® • Microsoft® Excel • Microsoft® Word • Microsoft® Outlook® User manuals are available via the “Help” menu in any of the above ...
  41. Econ

    How would you expect the return on a stock market fund to differ from the return on savings account? Why do you think the two rates of return differ?
  42. Economics

    How would you expect the return on a stock market fund to differ from the return on savings account? Why do you think the two rates of return differ?
  43. Finance - Required Return from a Beta

    Hi, I need to learn how to explain and solve the following Finance problem. I don't understand this at all!!!, please show all solutions... Calculate the required return on an asset that has a beta of 1.25, when the expected return on the market portfolio is 10% and the ...
  44. Finance

    Aset P has a beta of 0.9. The risk-free rate of return is 8%, while the return on the S&P 500 is 14%. Asset P's required rate of return is:
  45. Quantitative Methods

    I am trying to use the Goal Seek Method in Microsoft Excel but i keep getting a message that says "Cell must contain a value". Since the cell does contain a value what could be the error.
  46. Math

    Hi, I have been trying to figure this one math problem for awhile and I am stuck. I believe the answer is between A or B. Skip is practicing tennis serves against a wall. The distance between Skip and the tennis ball, in feet, at any time T, measured in seconds, is D(T)=-1.5(T...
  47. math

    Hi, I have been trying to figure this one math problem for awhile and I am stuck. I believe the answer is between A or B. Skip is practicing tennis serves against a wall. The distance between Skip and the tennis ball, in feet, at any time T, measured in seconds, is D(T)=-1.5(T...
  48. Math

    Consider the following spreadsheet: What formula would you use to calculate the number in cell B2? Cell A Cell B Cell C Cost of item 4% tax cost of before tax item with tax $130 5.2 $135.2 $150 6 $156 I do not know how to write a formula for calculate cell B.
  49. Math

    Consider the following spreadsheet: What formula would you use to calculate the number in cell B2? Cell A Cell B Cell C Cost of item 4% tax cost of before tax item with tax $130 5.2 $135.2 $150 6 $156 I do not know how to write a formula to calculate cell B.
  50. Finance Class Help (very very urgent) need asap

    K this is what I have so far. I am wondering if i did the CAPM right and if that is all i need for that part and then I need to know how to do the Constant Growth Model. When you do yours, assume the risk-free return as 6% Assume the expected market return 12% The beta, ...
  51. Finance

    Taggart Inc's stock has a 50% chance of producing a 21% return, a 30% chance of producing a 10% return, and a 20% chance of producing a -28% return.What is the firms expected rate of return? Please help
  52. lim

    I'm completely drawing a blank on how to do this. A woman has $500,000 invested into two real estate properties. One yields an annual return on 12% and the other returns 15% per year on her investment. Her total annual return from the two investments is $64,500. If X ...
  53. college algebra

    I'm completely drawing a blank on how to do this. A woman has $500,000 invested into two real estate properties. One yields an annual return on 12% and the other returns 15% per year on her investment. Her total annual return from the two investments is $64,500. If X ...
  54. ED TECH HELLLLPPP

    Selena needs to publish her research about Chinese culture. Her research includes audio clips from an interview with a Chinese citizen, written notes, and photographs from her tour of a Chinese exhibit in a local museum. Based on each application’s strengths and weaknesses, ...
  55. Software - Excel

    Hi, Im doing my maths coursework andI need to type in a formula and press enter and then I need "FILL DOWN (CTRL D)". How do I do this? I don't want to get the same number from what Ive alreay typed in on the previous cell, I just want that formula to function in the rest of ...
  56. business law

    Ann, an accountant, prepares a tax return for a client, Beta Sales Company. Carl, who is not an accountant, prepares a tax return for Dina's business, Delta Services. Can an accountant who prepares a tax return for a client be liable for any false statements in the return? Can...
  57. operating system

    How would you write a formula to multiply the number in a cell z675 times the number in cell a 1
  58. BUSINESS MATH

    : The Crescent Corporation just paid a dividend of $2 per share and is expected to continue paying the same amount each year for the next 4 years. If you have a required rate of return of 13%, plan to hold the stock for 4 years, and are confident that it will sell for $30 at ...
  59. BCIS

    You need to use the help section in your Excel program (press the F1 key and then use the search feature). If you need additional information about Excel, you can use your textbook or go to http://support.microsoft.com/search/, select the particluar program you want (there are...
  60. Business Finance

    Given the current financial information for both Microsoft and Coca Cola, how do calculate the expected dividend yield of Microsoft(MSFT) and Coca Cola(KO. The growth or capital gains yield? The total expected return for Microsoft and Coca Cola? I'm not quite sure what numbers...
  61. words

    12. You’ve created a pie chart in Excel and placed it in a PowerPoint presentation. When you edit the pie chart in Excel, the pie chart in PowerPoint doesn’t retain the changes you’ve made. This means that the object has been A. hyperlinked. C. linked. B. embedded. D. ...
  62. BUSINESS MATH

    Part B: The Crescent Corporation just paid a dividend of $2 per share and is expected to continue paying the same amount each year for the next 4 years. If you have a required rate of return of 13%, plan to hold the stock for 4 years, and are confident that it will sell for $...
  63. business

    A women has $500,000 invested in two rental properties. One yields an annual return of 14% on her investment, and the other returns 9% per year on her investment. Her total annual return from the two investments is $52,000. How much is invested at each return?
  64. Math

    A women has $500,000 invested in two rental properties. One yields an annual return of 14% on her investment, and the other returns 10% per year on her investment. Her total annual return from the two investments is $59,000. How much is invested at each return?
  65. microsoft excel 2003

    How would I graph equations in Microsoft Excel 2003 and the residuals? I want to graph linear, quadratic and exponential equations but I don't know how.
  66. Personal Finance

    1. You hold 20 shares of stock worth $12.75 per share on June 1. Over the next 12 months you receive total dividends of $.055 per share. On June 1 of the following year, each share is worth $12.95. a. Dividend return: -- b. Appreciation/Deprecation: -- c. Total return: -- d. ...
  67. Educational Technology.

    1. probability can be used to determine the likelihood of specific ________(fill in the blank). A. games B. occurrences C. questions D. opportunities 2. Tally marks are completed in groups of ______ because they are quick to mark and easier to count (fill in the blank). A. 2 B...
  68. Finance

    a. Calculate the values of the bonds if your required rates of return are as follows: Microsoft, 6 percent; Ford, 15 percent; Xerox, 10 percent; where MICROSOFT FORD XEROX Coupon interest rate 5.25% 7.13% 8.00% Years to maturity 30 25 16
  69. Quantitative methods

    Allen must decide whether to invest $10,000 in the stock market or in a certificate of deposit (CD) at an interest rate of 9%. If the market is good , he believes that he could get a 14% return on his money. With a fair market, he expects to get an 8% return. If the market is ...
  70. math (pre-calc)

    Analyzing a Stock. The beta, B of a stock represents the relative risk of a stock compared with a market basket of stocks, such as Standard and poor's 500 Index of stocks. Beta is computed by finding the slope of the line of best fit between the rate of return of the stock and...
  71. Data Analysis Help

    Arithmetic operations, cell references, and __________ can be used in Excel formulas. constants macros programs procedures is it A 2Using the mouse to select a specific cell is when creating a formula is called: sizing. moving. accessing. pointing. is it D 3.To ensure that the...
  72. finance

    Under normal conditions (70% probability), Financing Plan A will produce $24,000 higher return than Plan B. Under tight money conditions (30% probability), Plan A will produce $40,000 less than Plan B. What is the expected value of return for Plan A over Plan B? $28,800 $4,000...
  73. microsoft excell 2007

    entering the formula=SUM(C5:C18)is cell C19 will resolve in which of the following? (a)cells C5 and C18 will be added together (b)cells C5 and C18,and C19 will be added together (c)the total of cells C5 to C19 will appear in cell C19 (d0the total of cells C5 to C18 will appear...
  74. MATh

    Kesha dove from Buffalo to Syracuse at an average rate of 48miles per hour. On the return trip along the same road she was able to travel at an average rate of 60 miles per hour.The trip from Buffalo to Syracuse took one- half hour longer than the return trip. How long did the...
  75. algebra

    The formula for calculating the amount of money returned for an initial deposit into a bank account or CD (certificate of deposit) is given by nt n r P A „Ê„Ë „É „º„» „¹ ƒ­ 1ƒy A is the amount of the return. P is the principal amount initially deposited. r...
  76. *tough* Microsoft Excel 2007-not Writeacher again

    Could you please provide me with some reference material as to how vertical lookup works? All of the formula fields cause me to become clueless! What are lookup values, table arrays, column index numbers, and range lookups? As for what Writeacher proposed, I am already ...
  77. 5th grade Math

    I have a review question that says: The formula for the circumference of a circle is C = pi x d, where d represents the circle's diameter. Which statementis correct? Would it be D? Wasn't sure if a diameter could have a decimal or fraction. A. the formula only works if d is 1 ...
  78. Computer Science

    Answer the following question without running the code. The procedure isMyNumber is used to hide a secret number (integer). It takes an integer x as a parameter and compares it to the secret number. It returns: -1 if the parameter x is less than the secret number 0 if the ...
  79. math

    Skip is practicing tennis serves against a wall. The distance between Skip and the tennis ball, in feet, at any time T, measured in seconds, is D(T)=-1.5|T-8|+9. which analysis of the formula is true? A. Skip is 9 feet from the wall and the ball will return to him in 1.5 ...
  80. computer science

    hi i'm taking compsci and I need someone to give me some examples of these classes, thanks! You will have to write a class to represent one of the following items. Note that each class must a proper constructor even though the constructor is not explicitly named. 1. a Fraction...
  81. Math

    one Percentage increase / decrease formula in excel that full all the conditions that are mentioned below 2012 2011 1 0 0 2 0 500 3 500 0 4 500 1000 5 1000 500 6 500 (1000) 7 (1000) 500 8 (500) (1000) 9 (1000) (500) Dear its urgent
  82. Math

    one Percentage increase / decrease formula in excel that full all the conditions that are mentioned below 2012 2011 1 0 0 2 0 500 3 500 0 4 500 1000 5 1000 500 6 500 (1000) 7 (1000) 500 8 (500) (1000) 9 (1000) (500) Dear its urgent
  83. Finance/Algebra

    Suppose you bought an 8% coupon bond one year ago for $1090.00. The bond sells for $1063.00 today. Assuming a $1000 face value, what was ur total dollar return over the past year? What was the nominal rate of return over the past year? And, if inflation was 3%, what was ur ...
  84. Excel, Access, Word

    When you link a worksheet and a chart in a business report as well as on a slide, which Microsoft Office applications are integrated? A. Word, Excel, PowerPoint B. Excel, Access, Word C. Word, Access, PowerPoint D. Excel, PowerPoint, Publisher
  85. Math

    You are a share analyst for an investment firm and are investigating the return on shares in the Eastern Mining Corporation over the last four years. The return on Eastern Mining Corporation shares over the last four years is presented. Calculate the geometric mean rate of ...
  86. stats

    You are a share analyst for an investment firm and are investigating the return on shares in the Eastern Mining Corporation over the last four years. The return on Eastern Mining Corporation shares over the last four years is presented. Calculate the geometric mean rate of ...
  87. Computer

    I am finishing up an assignment in Microsoft Access and am having trouble understanding how to make this formula. The question states to write a query that shows each customer (Id, first and last name) along with the total amount of revenue for each customer (revenue=quantity*...
  88. Microsoft Excel

    The order of precedence is very important when building formulas in Excel. Which of the following formulas will produce 778 as the result? A. =(25*(27/9)+5+309)*2 B.=25*((27/9+5)+309*2) C.=25*(27/9+5)+309*2 D. =25*27/9+5+309*2 Even understanding the basics of Excel was ...
  89. Finance

    Consider the following two securities X and Y X y Return- 20.0% Return- 10.0% Standard Deviation- 20.0% Standard Dev 30% Beta- 1.50 Beta- 1.0 Risk-free asset Return- 5.0% Using the data from the table, what is the portfolio expected return and the portfolio beta if you invest ...
  90. Math

    Real Reverse Nominal Returns You purchase 100 shares of stock for $40 a share. The stock pays a $2 per share dividend at year-end. What is the rate of return on your investment for these end-of-year stock prices? What is your real (inflation-adjusted) rated of return? Assume ...
  91. business finance

    Her are the data on $1000 par value bonds issued by Microsoft, Ford, and Xerox at the end of 2008, Assume you are thinking about buying these bonds as of January 2009. Answer the following questions. a. Calculate the values of the bonds if your required rates of return are as ...
  92. maine s

    what is the rate of return on an initial investment of $2000 and you generate $500 return?
  93. economics

    what is the rate of return on an initial investment of $2000 and you generate $500 return?
  94. computers

    What is the return type of a method that does not return a value? A. null B. void C. 0(zero) D. int
  95. Computer Math

    Can anyone help me? Here's what I'm looking for: Col. A = Base period number Col. B = Given number this current period. NEEDED: Spreadsheet formula for: If B >= A, what is %? (Example: A=20, B=30, the # I want should read 50.0, not 1.5) Further, If B < A, what is the ...
  96. math pre-agebra

    how do i write this equation cars the marton family took a vacation that covered a total distance of 1356 miles. the return of the trip was 284 miles shorter than the first part of the trip. how long was the return trip?
  97. College Algebra~ Check answer please

    Can someone check my answers please. The formula for calculating the amount of money returned for an initial deposit into a bank account or CD (certificate of deposit) is given by A=P(a+r/n)^nt A is the amount of the return. P is the principal amount initially deposited. r is ...
  98. business

    Return on assets represents the total return on the net investment in the firm. True or False?
  99. Math

    Hello, I need to use matrices in order to solve this problem but I am having a hard time getting started with the problem. I just need a little push to nudge me in the right direction. Please help. Thank You. You have been hired as a consultant for Crazy Al’s Car Rentals, a ...
  100. Math

    Internal rate of return What is the internal rate of return for the following project. An initial outlay of $9500 resulting in a single cash inflow of $16,281 in 7 years. Internal rate of return for the project is ___%
  1. Pages:
  2. 1
  3. 2
  4. 3
  5. 4
  6. 5
  7. 6
  8. 7
  9. 8
  10. 9
  11. 10
  12. 11
  13. 12
  14. 13
  15. 14
  16. 15
  17. 16
  18. 17
  19. 18
  20. 19
  21. 20
  22. 21
  23. 22
  24. 23
  25. 24
  26. 25
  27. 26
  28. 27
  29. 28
  30. 29
  31. 30
  32. 31
  33. 32
  34. 33
  35. 34
  36. 35
  37. 36
  38. 37
  39. 38
  40. 39
  41. 40
  42. 41
  43. 42
  44. 43
  45. 44
  46. 45
  47. 46
  48. 47
  49. 48
  50. 49
  51. 50
  52. 51
  53. 52
  54. 53
  55. 54
  56. 55
  57. 56
  58. 57
  59. 58
  60. 59
  61. 60
  62. 61
  63. 62
  64. 63
  65. 64
  66. 65
  67. 66
  68. 67
  69. 68
  70. 69
  71. 70
  72. 71
  73. 72
  74. 73
  75. 74
  76. 75
  77. 76
  78. 77
  79. 78
  80. 79
  81. 80
  82. 81
  83. 82
  84. 83
  85. 84
  86. 85
  87. 86
  88. 87
  89. 88
  90. 89
  91. 90
  92. 91
  93. 92
  94. 93
  95. 94
  96. 95
  97. 96
  98. 97
  99. 98
  100. 99
  101. 100