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.

What is ransomware and how do I protect my PC from WannaCry?

What I learned from my mentor, Oscar-winning VFX supervisor Phil Tippett

Siri vs Google Assistant