Help with #REF! error
I'm really not that good with excel so if someone could help me out I'd appreciate it.
This is a simple algebraic equation that solves for x. Go ahead and laugh at my "paint" job
Here is the equation: =SUM((((C18-F18)/G18)/(H18(1+(D18/100))))-1)*100
FRF ErrorJ.jpg
Thanks for your help!
You need some sort of operator between H18 and (1+(D18/100)). Excel will not assume multiplication.
=SUM((((C18-F18)/G18)/(H18*(1+(D18/100))))-1)*100
what is the operand here
(H18?(1+(D18/100))))
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
You need a multiplier between H18 and the open parenthesis... and you don't need SUM function (redundant)
=((((C18-F18)/G18)/(H18*(1+(D18/100))))-1)*100
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Hey jcfish,
Welcome to the forum.
Paint job is good but would like to have a look on sample file as well, please upload. Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey
+919810929744
dilipandey@gmail.com
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks