Roundup

[dgavin]

I use the formula

=SUM((X37-1)/(AB37-1)-1)*100

but i want to roundup the result by 2 decimal places.

can i do this in the same formula, or do i have to do it in a separate cell ?

 

[Rick Rothstein]

Functions can be embedded within functions (up to the nesting level of your version of Excel), so if I understand your question correctly, this should do what you asked...

=ROUND(SUM((X37-1)/(AB37-1)-1)*100,2)