S
Sulasno
want to add 1+2+3 = (6)
how do to it?
how do to it?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
=SUM(1,2,3)
D
Don Guillett
=sum(1,2,3)
M
MartinW
Hi Sulasno,
A few different ways,
In cell A1 type =1+2+3 and enter
or
Put 1 in A1, 2 in A2, 3 in A3,
Then in A4 put =A1+A2+A3
Then in A5 put =SUM(A1:A3)
That's three ways of achieving the same outcome.
The thing with Excel is there is no hard and fast rule that
says one particular way is the best way. There are many ways
to achieve what you are trying to do and the only criteria
for the best way is what suits what you are trying to achieve
at the time.
HTH
Martin
A few different ways,
In cell A1 type =1+2+3 and enter
or
Put 1 in A1, 2 in A2, 3 in A3,
Then in A4 put =A1+A2+A3
Then in A5 put =SUM(A1:A3)
That's three ways of achieving the same outcome.
The thing with Excel is there is no hard and fast rule that
says one particular way is the best way. There are many ways
to achieve what you are trying to do and the only criteria
for the best way is what suits what you are trying to achieve
at the time.
HTH
Martin
S
Sulasno
guess I did not pose the correct question
I want the end result to be in brackets
=sum(xxxx) =(total)
I want the end result to be in brackets
=sum(xxxx) =(total)
P
Peo Sjoblom
No you didn't, use custom formats like
(General)
or
(0.00)
(General)
or
(0.00)
R
Ron Rosenfeld
want to add 1+2+3 = (6)
how do to it?
Custom Format your cell
Format/Cells/Number/Custom Type: (General)
You should be aware that there is a convention that considers numbers enclosed
in parentheses as being negative numbers
--ron
S
Sulasno
thanks
it works
it works
Peo Sjoblom said:No you didn't, use custom formats like
(General)
or
(0.00)