If Function Roundup

[Tazlady34]

I have a formula on my spreadsheet
=IF(G5>M5,M5,G5)
that gives a result of 705470.61

I want the result to be rounded up
when i put the formula in brackets and roundup in front that doesnt work
what am i doing wrong. (note: i did try to format cell and got rid of dec places but that didnt work because later i add these cells and want to add the rounded up number)

 

[gaz_chops]

=IF(G5>M5,ROUNDUP(M5,0),ROUNDUP(G5,0))

 

[TommyGun]

This works without being an array formula...

=ROUNDUP(IF(G5>M5,M5,G5),0)

 

[Tazlady34]

=IF(G5>M5,ROUNDUP(M5,0),ROUNDUP(G5,0))

This formula was wonderful...thanks for your help

 

[Tazlady34]

The first time i put the formulas in that yall helped me with the first worked and second didnt...but just went and did it again and they both work...thank you for your time and help

 

[Obwan]

=IF(G5>M5,ROUNDUP(M5,0),ROUNDUP(G5,0))

How do I use roundup with formula?
=IF(B4<A4,SUM(A4-B4)/$A$1,"Achieved")

I tried =ROUNDUP(IF(B4<A4,SUM(A4-B4)/$A$1,"Achieved"),0) but I get #Value instead of Achieved>
Thank you in advance

 

[joeu2004]

@Obwan.... You are "responding" to a 16-year-old (!) thread. Also, I think your posting got mangled by this forum's GUI.

I suggest that you repost by starting your own thread. If it includes "<" or ">", be sure to type spaces around the symbol.