want to add 1+2+3 = (6)

how do to it?

=SUM(1,2,3)


--
Regards,

Peo Sjoblom



"Sulasno" wrote in message
...
want to add 1+2+3 = (6)

how do to it?

=sum(1,2,3)


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sulasno" wrote in message
...
want to add 1+2+3 = (6)

how do to it?

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


"Sulasno" wrote in message
...
want to add 1+2+3 = (6)

how do to it?

guess I did not pose the correct question

I want the end result to be in brackets

=sum(xxxx) =(total)


"Don Guillett" wrote in message
...
=sum(1,2,3)


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sulasno" wrote in message
...
want to add 1+2+3 = (6)

how do to it?

No you didn't, use custom formats like

(General)

or

(0.00)





--
Regards,

Peo Sjoblom



"Sulasno" wrote in message
...
guess I did not pose the correct question

I want the end result to be in brackets

=sum(xxxx) =(total)


"Don Guillett" wrote in message
...
=sum(1,2,3)


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sulasno" wrote in message
...
want to add 1+2+3 = (6)

how do to it?

On Fri, 7 Sep 2007 22:41:32 +0700, "Sulasno" wrote:

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

thanks
it works

"Peo Sjoblom" wrote in message
...
No you didn't, use custom formats like

(General)

or

(0.00)





--
Regards,

Peo Sjoblom



"Sulasno" wrote in message
...
guess I did not pose the correct question

I want the end result to be in brackets

=sum(xxxx) =(total)


"Don Guillett" wrote in message
...
=sum(1,2,3)


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sulasno" wrote in message
...
want to add 1+2+3 = (6)

how do to it?