I am trying to shorten the following formula but can't work out how to do it.
=10*LOG((10^(B4/10)+10^(C4/10)+10^(D4/10)+10^(E4/10)+10^(F4/10)+10^(G4/10)+10^(H4/10)+10^(I4/10))/8)
As can be seen there is quite a lot of repetition. I came up with the following formula but get a #VALUE! error when using it
=10*LOG(SUM(10^(B4:I4/10))/COUNTA(B4:I4)).
Any help would be appreciated!
I think you just have to schlepp that one. fr 10*LOG((10^3+10^2)/8)=10*LOG(1100/8)=10*LOG(137.5)=21.38303
Last edited by xladept; 02-04-2013 at 08:11 PM.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Hello jonpleasetalk,
Welcome to the Forum!
Copy and Paste this formula on to the worksheet. After you copy the formula, enter it using Ctrl+Shift+Enter because this is an array formula.=10*(LOG(SUM(10^(B4:I4/10)/8)))
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Ah, i see. Thank you for your help!
My code also works if used in array formula format. Just didn't know about that.
thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks