software

Is there any way to have 2 functions in one cell? I have a =sum function in
a cell and i want to round that value from that function can it be done?

=ROUND(SUM(rng),2)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;colleenquot; gt; wrote in message
...
gt; Is there any way to have 2 functions in one cell? I have a =sum function
in
gt; a cell and i want to round that value from that function can it be done?
Sure. For instance:

=ROUND(SUM(A1:A6),2) will round the sum of a1 through a6 to two digits

quot;colleenquot; wrote:

gt; Is there any way to have 2 functions in one cell? I have a =sum function in
gt; a cell and i want to round that value from that function can it be done?