Need to add multiplication to an array formula

[leopardhawk]

Hello forum friends, I am trying to add a multiplier to an existing array formula but it is giving me, not an error, but the wrong result. The formula as it exists is returning a result of 24. I want to multiply this result by 0.621371 but when I add *0.621371 to the end of the formula and do a ctrl-shift-enter, the result is -8731...???

As always, I appreciate any help, advice or guidance.

Thanks!

{=SUM(E206:E228-OFFSET(E206:E228,-1,1))+MAX(F206:F228)}

 

[DanteAmor]

Try this

{=(SUM(E206:E228-OFFSET(E206:E228,-1,1))+MAX(F206:F228))*0.621371}

 

[DanteAmor]

In fact you don't need an array formula, it can be like that

=(SUM(E206:E228)-SUM(F205:F227)+MAX(F206:F228))*0.621371

 

[leopardhawk]

Dante, thank you for reaching out to help. The first suggestion you made gives the same result (-8731) even after I added the missing parenthesis at the end. The second suggestion returns a result of 484 when the correct result should be 14.9 (24*0.621371).

Not sure why...

 

[DanteAmor]

Check the parentheses of the first option well, cannot do the same with or without.

 

[leopardhawk]

Thank you so much! As always, you are correct, I had a parenthesis in the wrong location.

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.