Get instant live expert help on I need help with calculate range in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I am trying to create a formula in Excel that will calculate a range for me. For example. I have a student who's Lexile is 1110. I want to create a formula that will automatically calculate the lowest and highest Lexile she can chose from. The range should be 50 lower and 100 higher than 1110.
Solved by F. F. in 15 mins
4. In Cell B5, a customer has an account balance of $80,000, how long would you calculate they have been with the company? (Forecast)
5. In Cell B6, determine the variance within your forecast. (Confidence.norm)
6. In Cell B7, calculate the high range of this forecast (Addition)
7. In Cell B8, calculate the low range of this forecast (Subtraction)
Solved by S. H. in 22 mins
I need to calculate a numbers within a range
Solved by G. H. in 12 mins
In cell E11, enter a financial function to calculate the interest paid. Copy the formula to the range E12:E34. The result should be a positive value. In cell F11, enter a financial function to calculate the principal payment. Copy the function to the range F12:F34. The result should be a positive value. In cell G11, enter a formula to calculate the ending balance. Copy the formula to the range G12:G34. Adjust the width of column G, if needed, to display the values. Select the range D11:G34 and apply Accounting Number Format.
Solved by V. S. in 16 mins
how to make a formula calculate within a date range
Solved by F. F. in 26 mins