F Frafi Nov 5, 2003 #1 Can have have a particular spreadsheeet always round numbers upwards. For example, 25.3 would be 26? Thanks for any help
Can have have a particular spreadsheeet always round numbers upwards. For example, 25.3 would be 26? Thanks for any help
R Ron Rosenfeld Nov 5, 2003 #2 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
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 Nov 6, 2003 #3 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
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 Nov 8, 2003 #4 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...
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...
