Forcing numbers to round up not down

  • Thread starter Thread starter barch78
  • Start date Start date
B

barch78

I have a formula that gives me the number of weeks in a period. How ca
I get the fractions of a week to round up instead of down.
For example, if the formula returns 15.1 weeks, I want the value to b
16 weeks
 
Hi Barch,
Try =CEILING(15.1,1).

You can replace 15.1 with a formula (resulting in 15.1) or a cellreference.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Hi Barch78!

Try:
=ROUNDUP((B1-A1)/7,0)
or:
=CEILING((B1-A1)/7,1)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top