Posted to microsoft.public.excel.misc

Pammy

external usenet poster

Posts: 96

divide and round up

I have a formula: c5/4
I want a formula to divide: c5/4 then round up to a whole number. example:

if the answer is 17.3 I want the answer to be 18.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Divide and round	osaka78	Excel Discussion (Misc queries)	15	July 31st 07 04:12 AM
Format divide by 10 / single digit view: Custom? Text(Round(	nastech	Excel Discussion (Misc queries)	0	June 27th 06 11:03 PM
Divide by Zero	rocky	Excel Worksheet Functions	3	April 22nd 05 12:50 PM
Divide one row over other row I dont wont to divide one number	Rick	Excel Discussion (Misc queries)	0	March 4th 05 07:13 PM
How do I ROUND() round off decimals of a column dataset?	HÃ¸jrup	Excel Worksheet Functions	2	January 12th 05 10:50 AM

All times are GMT +1. The time now is 01:02 PM.

About Us

"It's about Microsoft Excel"