divide and round up

P

Pammy

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.
 

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

Summing VLookup from a variable number of sheets 4
Reference to another worksheet cell in a sumproduct formula 1
Copy a Formula in a Macro 3
divide a month's target into weeks 4
Contents 1
Content 2
Conditional Formatting a Formula Field 3
how can i use a whole number after dividing? 3

Top