Hello,
I am looking for assistance for the proper place to add a roundup to this iferror formula below?
=IFERROR(G28/(G28+G29)*H19,0)
I appreciate any help.
Thank you,
Nick
Hello,
I am looking for assistance for the proper place to add a roundup to this iferror formula below?
=IFERROR(G28/(G28+G29)*H19,0)
I appreciate any help.
Thank you,
Nick
Roundup wraps your calculation:
=IFERROR(ROUNDUP(G28/(G28+G29)*H19,?),0)
Ben Van Johnson
Untested, but try:Formula:Please Login or Register to view this content.
Is this different to the previous ROUNDUP question?
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Basically, the same issue as this thread: https://www.excelforum.com/excel-gen...ml#post5948070
Just wrap the ROUNDUP round the calculation.
Thanks, I wasn't putting the iferror 0 outiside. Thanks both for your help.
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks