how to add ( and ) when using function sum

[Sulasno]

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

how do to it?

 

[Peo Sjoblom]

=SUM(1,2,3)

 

[Don Guillett]

=sum(1,2,3)

 

[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

 

[Sulasno]

guess I did not pose the correct question

I want the end result to be in brackets

=sum(xxxx) =(total)

 

[Peo Sjoblom]

No you didn't, use custom formats like

(General)

or

(0.00)

 

[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

 

[Sulasno]

thanks
it works

No you didn't, use custom formats like

(General)

or

(0.00)