rounding numbers

F

Frafi

Can have have a particular spreadsheeet always round numbers upwards. For
example,
25.3 would be 26?
Thanks for any help
 
R

Ron Rosenfeld

Can have have a particular spreadsheeet always round numbers upwards. For
example,
25.3 would be 26?
Thanks for any help
Click to expand...

Look at HELP for the ROUNDUP and CEILING Worksheet Functions


--ron
 
N

NealUK

You could use the ROUNDUP function
for example if A1 contains 25.3, and B1 contains =ROUNDUP(A1,0) will give 26
That should do the trick
regards
Neal
 
F

Frafi

Thanks for the help.
NealUK said:
You could use the ROUNDUP function
for example if A1 contains 25.3, and B1 contains =ROUNDUP(A1,0) will give 26
That should do the trick
regards
Neal
Click to expand...
 

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

Saving Previous Data before editing 6
Organizing a group of notebooks 0
Sum and round 4
Rounding up 7
Round up to nearest 25 or 50? 6
Formula to round based on thousandths place 4
rounding a number up to a certain ending digit 6
Round up price to end .99 2

Top