I was needing to find the next end of quarter (based on today's date), and found your CEILING solution. What a great solution! FYI if it helps anyone...
=EOMONTH(DATE(YEAR(TodaysDate),CEILING(MONTH(TodaysDate),3),1),0)
where TodaysDate could be NOW() or some other date.
Peo Sjoblom wrote:
Or without any division and multiplying=CEILING(A1,5)-- Regards,Peo
29-Jun-07
Or without any division and multiplying
=CEILING(A1,5)
--
Regards,
Peo Sjoblom
Previous Posts In This Thread:
MROUND to only round up
I am using MROUND to the nearest 5. And I need it to only round up.
Is this possible?
(this is a formula for sizing a container, so if the item's width is
22" for example, my container needs to be 25").
Any suggestions would be great - thanks. laurie
You can't do it with MROUND, but applying a bit of maths and using ROUNDUP
You can't do it with MROUND, but applying a bit of maths and using ROUNDUP
will get you what you want.
Divide your value by 5, round up to the next whole number by specifying 0
decimal places, then multiply by 5
=ROUNDUP(A1/5,0)*5
--
Ian
--
Or without any division and multiplying=CEILING(A1,5)-- Regards,Peo
Or without any division and multiplying
=CEILING(A1,5)
--
Regards,
Peo Sjoblom
There always seems to be a keyword for what you need.
There always seems to be a keyword for what you need. I'd never come across
CEILING before. Nice solution!
--
Ian
--
Re: MROUND to only round up
FLOOR does the opposite and rounds down
--
Regards,
Peo Sjoblom
Thanks for the pointer. Hopefully CEILING is what terrapinie wants.
Thanks for the pointer. Hopefully CEILING is what terrapinie wants.
--
Ian
--
Thanks guys!! I will try the CEILING function tomorrow when I getback to work.
Thanks guys!! I will try the CEILING function tomorrow when I get
back to work.
Submitted via EggHeadCafe - Software Developer Portal of Choice
WCF Data Services / WCF Behaviors And Server Side Processing
http://www.eggheadcafe.com/tutorial...wcf-behaviors-and-server-side-processing.aspx