Excel ROUNDUP Formula

  Abel 08:40 20 Apr 2008
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 2008

Is this what you want?

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

  Abel 08:52 20 Apr 2008

Precisely VoG™! Those pesky brackets! Many thanks

Abel

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

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

How to update iOS on iPhone or iPad

Les meilleures applications pour enfants 2017