HomeworkLib
Question

91.53% 83.01% 89.45% 92% 84% 90%

Need an excel formula to round numbers, 83.01% needs to be rounded up to 84 - please provide excel method forumula

math   Statistics-And-Probability   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Excel function is : =ROUNDUP (83.01% , 2)

  

0 0
Add a comment
Know the answer?
Add Answer to:
Need an excel formula to round numbers, 83.01% needs to be rounded up to 84 -...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Please don't provide the answer by excel calculation. I need to understand the formula and step...

    Please don't provide the answer by excel calculation. I need to understand the formula and step by step.Thank you. 5. Compare the following two alternatives by the IRR method, given MARR of 8%/year. Is the incement in cost form A to B justified? Construction cost $ Benefits $/yr Salvage $ Service Life (yrs) 510,000 145,000 10,000 11 775,000 155,000 20,000 12

  • NEED EXCEL SOLUTION: EXCEL FORMULA ONLY PLEASE 1. Cost of Equity: Stock quote link Stock price:...

    NEED EXCEL SOLUTION: EXCEL FORMULA ONLY PLEASE 1. Cost of Equity: Stock quote link Stock price: $                                           65.95 Dividend: $                                             1.66 Key statistics link Beta:                                                  1.43 Shares outstanding:                                   148,610,000 Analysts' estimates link 5-year dividend growth: 6.85% Bond center link: Risk-free rate: 0.13% Market Risk Premium: 7.00% Cost of Equity: Use DDM: r = D/P + g Cost of Equity: Use CAPM: r = rf + B * (Rm - Rf) Please provide Excel solutions for the above two...

  • NEED EXCEL SOLUTION PLEASE: (EXCEL FORMULA) Suppose we have the following returns for the market and...

    NEED EXCEL SOLUTION PLEASE: (EXCEL FORMULA) Suppose we have the following returns for the market and a stock: Year Market return Stock return 1 18% 7% 2 27% 25% 3 5% 21% 4 13% 4% 5 -17% -16% 6 6% 19% 7 -21% -38% 8 34% 29% 9 19% 15% 10 11% 16% What is the covariance and correlation of the returns between this stock and the market? Covariance: Use Covar Function Correlation: Use Correl Function Beta: Use Slope Function...

  • Please provide an excel Formula for the last 2 questions, cell reference is not required. Thank...

    Please provide an excel Formula for the last 2 questions, cell reference is not required. Thank You Using the numbers below, answer the questions using nested formulas 14 11 15 30 28 15 25 11 41 20 20 50 6 24 20 28 47 Add all the numbers together using SUM and round them with ROUND Use SUM to add 5 to the AVERAGE of all the numbers above Use SUM to add the MIN and MAX numbers from the...

  • NEED EXCEL SOLUTION PLEASE: EXCEL FORMULA ONLY Calculating returns in Excel is a relatively simple matter...

    NEED EXCEL SOLUTION PLEASE: EXCEL FORMULA ONLY Calculating returns in Excel is a relatively simple matter since we only need to input basic equations. Consider the information from the Video Concepts Company: Shares:                  100 Beginning price: $           37.00 Ending price: $           40.33 Dividend per share: $             1.85 With this information, we can calculate the dollar returns and percentage returns as: Total dollar capital gains: Dividend income: Total dollar return: Capital gains return: Dividend yield: Total return:

  • ** need formula or excel formula please You are considering the purchase of a stock that...

    ** need formula or excel formula please You are considering the purchase of a stock that reported earnings per share of $2.68 in the most recent fiscal year. You expect the firm’s earnings to grow at 18% for the next ten years. After that you feel the growth in earnings will be 2.50% into the future. If you require a return of 15% on such an investment, what are you willing to pay for the shares today?

  • *need to be solved manually, not with the NORMINV excel formula. All the solution to my...

    *need to be solved manually, not with the NORMINV excel formula. All the solution to my practice problems use the excel way of solving them and I won't have access to excel during the exam, therefore they have to be done manually* Consider the following information for a product: Lead time is 3 weeks. The average weekly demand is 1500 and weekly standard deviation is 300. If company wants to have cycle service level of 90%. What should the safety...

  • NEED EXCEL SOLUTION: EXCEL FORMULA ONLY PLEASE Find Cost of Debt: Suppose the average bond information...

    NEED EXCEL SOLUTION: EXCEL FORMULA ONLY PLEASE Find Cost of Debt: Suppose the average bond information is below for an annual coupon paying bond: Maturity 5 Coupon 4.00% FV $5,000.00 P $4,500.00 YTM

  • - Please answer the questions using an Excel Formula - Answers need to be an Excel...

    - Please answer the questions using an Excel Formula - Answers need to be an Excel Formula Thank you חד H $ $ A B C D E G 193 Cleaning Service 194 You are running a cleaning service. 195 During the winter you also provide snow removal services. 196 Write the Excel formula in the yellow cells below that calculate the appropriate values. 197 198 Receive $150,000 from customers for cleaning services provided. 199 Receive $50,000 from customers for...

  • Need to graph in excel, complete numbers 1 and 2. will thumbs up for completing correctly....

    Need to graph in excel, complete numbers 1 and 2. will thumbs up for completing correctly. thank you The decomposition of ozone is important to many atmospheric reactions: 03 (9) 02 (9) + 0 (9) A study of the kinetics of the reaction resulted in the following data: Temperature (K) Rate Constant ( Ms) Temperature (K) Rate Constant (M 1.54) 600 3.37 x 10 1300 7.83 x 10 700 4.85 x 104 1400 1.45 x 100 800 3.58 x 10...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT