F
Frafi
Can have have a particular spreadsheeet always round numbers upwards. For
example,
25.3 would be 26?
Thanks for any help
example,
25.3 would be 26?
Thanks for any help
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Ron Rosenfeld
Can have have a particular spreadsheeet always round numbers upwards. For
example,
25.3 would be 26?
Thanks for any help
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
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