Excel ROUNDUP Formula

  Abel 08:40 20 Apr 08
Locked

Your help please! Can theExcel function 'ROUNDUP' be nested? I'm trying to add together two calculations, each of which needs individually to be rounded-up to the second decimal place. The formula I've used is this: ROUNDUP((5009-8.84)/52,ROUNDUP((439/52),2)). However, it returns only the answer to the first part of the equation.

Abel

  VoG II 08:45 20 Apr 08

Is this what you want?

=ROUNDUP((5009-8.84)/52,2)+ROUNDUP(439/52,2)

  Abel 08:52 20 Apr 08

Precisely VoG™! Those pesky brackets! Many thanks

Abel

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

VFX Oscar nominees 2017: Discover how the visual effects were created

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…