Thread: How do I round up fractions to the next whole number?
View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default How do I round up fractions to the next whole number?
One way:

=CEILING(A1,1)

In article ,
"JHL1927" wrote:

I want to round up a number to the next whole number Ex: Round up 1.2 to 2.0
Reply With QuoteReply With Quote