How to round up a number?

G

Guest

Does anyone have any suggestions on how to round up a number? such as
If the value in cell A1 is 3, then return 3, but
If the value in cell A1 is 3.1, then round it up to 4.
Does anyone have any suggestions?
Thank in advance
Eric
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to set the value - 28 Nov? 1
How to determine the number? 8
round up the number 7
How to set the value? 6
How to find the number? 7
How to locate the value? 1
How to determine char or number? 4
Round up or down by set variable 3

Top