Combining formulae

[mandrax]

A very simple question here. I want to first calculate the sum of multiple cells, and then round them up to two decimal points. So what I'm trying to do is combine the following calculations into one formula:

=SUM(K12:K31)

and

=ROUNDUP(K27, 2)


thanks

m

[Stuie]

Hi mandrax,

Try this

=ROUNDUP(SUM(K12:K31), 2)

I have assumed K27 is where the sum formula is

[mandrax]

that worked - THANKS!!!