Hi all,
I'm trying to write a formula to find the square root of a =sum formula, within the same formula.
=SUM(AD8*AD8+AD9*AD9+AD10*AD10+AD11*AD11+AD12*AD12) - I'm trying to find the square root of the total of this.
So I tried:
=SQRT((=SUM(AD8*AD8+AD9*AD9+AD10*AD10+AD11*AD11+AD12*AD12)
... But that didn't work.
Anyone know where I'm going wrong?
Last edited by Treeman_JF; 12-10-2020 at 01:44 PM.
In what way did it not work? Did you get an error message, or an answer that is obviously wrong?
You need to amend your formula like this:
=SQRT(SUM(AD8*AD8+AD9*AD9+AD10*AD10+AD11*AD11+AD12*AD12))
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks