how to add ( and ) when using function sum
 

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

how do to it?

how to add ( and ) when using function sum
 

=SUM(1,2,3)


--
Regards,

Peo Sjoblom



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

how do to it?

how to add ( and ) when using function sum
 

=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?

how to add ( and ) when using function sum
 

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?

how to add ( and ) when using function sum
 

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?

how to add ( and ) when using function sum
 

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?

how to add ( and ) when using function sum
 

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

how to add ( and ) when using function sum
 

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?