Need to add multiplication to an array formula

leopardhawk

Active Member
Joined
May 31, 2007
Messages
356
Office Version
2016
Platform
Windows
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!

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

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
7,891
Office Version
2007
Platform
Windows
Try this

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

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
7,891
Office Version
2007
Platform
Windows
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

Active Member
Joined
May 31, 2007
Messages
356
Office Version
2016
Platform
Windows
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

Well-known Member
Joined
Dec 3, 2018
Messages
7,891
Office Version
2007
Platform
Windows
Check the parentheses of the first option well, cannot do the same with or without.
 

leopardhawk

Active Member
Joined
May 31, 2007
Messages
356
Office Version
2016
Platform
Windows
Thank you so much! As always, you are correct, I had a parenthesis in the wrong location.
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
7,891
Office Version
2007
Platform
Windows
I'm glad to help you. Thanks for the feedback.
 

Forum statistics

Threads
1,078,367
Messages
5,339,783
Members
399,323
Latest member
letitiaysk

Some videos you may like

This Week's Hot Topics

Top