“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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