View Single Post
 
Old 09-27-2023, 01:46 PM
kilroyscarnival kilroyscarnival is offline Windows 10 Office 2021
Expert
 
Join Date: May 2019
Posts: 361
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Quote:
Originally Posted by otuatail View Post
No it dosn't
=(INT(SUM(10.8))) returns 10
=ROUND((INT(SUM(10.8)))) returns an error message. Same as ROUNDUP did.

You entered too few arguments for this function.
You would just use =INT, not =INT(SUM(*), and certainly not =ROUND((INT(SUM(*).

Try =INT(10.8)
and
=ROUND(10.8,0) - where the comma and zero tell it what to round TO (zero decimal places.)
Reply With Quote