Last time I got pointed to LookUp. This... likely won't do it.
((A4^A$3)*A$2)+((B4^B$3)*B$2)+...
Is there a way to avoid writing this all out, but still leave the row with an unspecified number of entries since more might be added?
Is there a better way?
Is there a better way?
Open Office 4.0 on Win 7
Re: Is there a better way?
A partial formula like that is next to useless.
If you can't provide a full formula that shows what you are trying to do, even if the formula doesn't work, then we need an explanation as to what it is you are trying to do.
Based on what I can see, my first guess is that you want to put row 4 to the exponent row 3, then multiply that by row 2 for an unknown (possibly variable) number of columns.
If that is correct, then I can't (at the moment) think of another way of doing it, except for writing it all out. Fortunately if you do have to write it all out, any entries in row 2, 3, or 4 that are 0 will calculate to a 0 for the summation.
If you can't provide a full formula that shows what you are trying to do, even if the formula doesn't work, then we need an explanation as to what it is you are trying to do.
Based on what I can see, my first guess is that you want to put row 4 to the exponent row 3, then multiply that by row 2 for an unknown (possibly variable) number of columns.
If that is correct, then I can't (at the moment) think of another way of doing it, except for writing it all out. Fortunately if you do have to write it all out, any entries in row 2, 3, or 4 that are 0 will calculate to a 0 for the summation.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
Re: Is there a better way?
Sorry, I'm not sure I understand what you're looking for.Robindude wrote:Is there a way to avoid writing this all out, but still leave the row with an unspecified number of entries since more might be added?
Maybe something like this:
=SUMPRODUCT((A4:E4^A3:E3)*A2:E2)
That will calculate the sum of the terms in columns A to E; empty columns will evaluate to zero so they are effectively ignored. You can change the formula to allow for a larger number of terms but it won't adjust as you fill in the cells.
AOO4/LO5 • Linux • Fedora 23
Re: Is there a better way?
Please upload your ODF type example file here.Last time I got pointed to LookUp. This... likely won't do it.
((A4^A$3)*A$2)+((B4^B$3)*B$2)+...
Is there a way to avoid writing this all out, but still leave the row with an unspecified number of entries since more might be added?
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Is there a better way?
Use CSE formulas:
If you give names to areas, use them, eg:
The CSE formula will be created after the CTRL+SHIFT+ENTER
Expansion you do not need to enclose in parentheses. The order of calculations is: exponentiation, multiplication and division, addition and subtraction
Code: Select all
=SUM(A4:G4^A3:G3*A2:G2)Code: Select all
=SUM(area1^area2*area3)Expansion you do not need to enclose in parentheses. The order of calculations is: exponentiation, multiplication and division, addition and subtraction
AOO 4.1.7, LibreOffice 6.2.8
Windows 10 64 bits
Windows 10 64 bits