PDA

View Full Version : Can't get a result of formula



Aleksey
09-06-2007, 11:10 PM
I can't get a result of calculations in the cell.
In an attached file I have described what I need and 2 variants that I tried. But they work too long (Var 1) and doesn't work (Var 2).
May be someone can help me? Pleeeeeeas.

Barryj
09-06-2007, 11:30 PM
This is the result of the =SUM(10+20*3.5*2*3*4) it comes to 1920

You just needed to put the =SUM in front of your formula the rest was correct.

Aleksey
09-06-2007, 11:40 PM
At first it must calculate numbers in brackets and then other. And a result must be 1920.

Barryj
09-06-2007, 11:53 PM
When I calculated it as per your formula it comes to 1920, is that what you are after. this formula provides 1920 as the answer:
=SUM(10+20*3.5*2*3*4)

unmarkedhelicopter
09-07-2007, 01:24 AM
The "SUM" part is completely irrelevant if you only have one value (which you have, it is not an array, i.e. 7, 9, 221 - values separated by spaces to be summed or a range of cells)

The rest is a result of standard reverse polish notation :-
10 + 20 * 3.5 * 2 * 3 * 4 equates to :-
10 + (20 * 3.5 * 2 * 3 * 4) equates to :-
1690 (not 1920 at all)

you could modify the above to :-
(10 + 20) * 3.5 * 2 * 3 * 4 equates to
30 * 3.5 * 2 * 3 * 4 eqautes to
2520 (again not 1920 at all)

Looking at your spreadsheet you asked for :-
(10+20*3.5)*2*3*4 .... and that comes to .... (wait for it) .... (let the tension build) .... 1920
so you just enter =(10+20*3.5)*2*3*4 in the cell and guess what ? ... you get 1920.

Barryj
09-07-2007, 05:09 AM
When I added all that together by the calculation given I got 1920? but I still don't understand the question to the result? =SUM(10+20*3.5*2*3*4).

unmarkedhelicopter
09-07-2007, 07:16 AM
When I added all that together by the calculation given I got 1920? but I still don't understand the question to the result? =SUM(10+20*3.5*2*3*4).

Eh ! ... Was that a statement, a question or both ?