0

I have attached a pic of what I am trying to do. The goal is to get LAMBDA to subtract the previous cell and then average that. (AVERAGE RATE OF CHANGE)

Improve this question
3
  • What is your excel version? LAMBDA() is only available Excel 365 latest release. Commented Jun 26, 2022 at 7:34
  • 1
    I can't reproduce the error, it runs fine on my setup. Might be worth mentioning that the average rate of change is just (last value - first value) / (number of values - 1) i.e. 1/24 for your data. Commented Jun 26, 2022 at 8:04
  • @TomSharpe This nugget of information is what I was looking for! Thanks Commented Jun 26, 2022 at 16:24
Related questions
0
Excel VBA Function Giving # Value Error when trying to use in Excel formulas
0
Function Returns #Value Error sometimes
0
Can't get rid of VALUE error when using excel-formula
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.