How to ROUNDUP existing formula that returns anything over 0

[thewiseguy]

Hi all,

Currently using this formula:

=SUMPRODUCT(('Helper 4'!$C:$C=B24)*'Helper 4'!$D:$D)

This is giving me a value of .25

How can I get this to roundup to 1?

Thank you in advance!

 

[dreid1011]

Besides that example, what significant digit are you wanting to round to?

Either way:

=ROUNDUP( current formula,0)

Or

=CEILING.MATH( current formula,1)

 

[thewiseguy]

Worked perfectly. Thank you!

 

[dreid1011]

You're welcome, and happy to help.