Posted to microsoft.public.excel.programming

Shawn

external usenet poster

Posts: 271

rounding error

How can I restrict a cell so that it will only accept whole numbers between 1
and 24, or a decimal number between .25 and 23.75? The decimal answers can
only be .25, .5 or .75?

--
Thanks
Shawn

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
rounding error	pkeegs	Excel Discussion (Misc queries)	2	January 13th 10 07:53 AM
rounding error?	Steve	Excel Discussion (Misc queries)	5	June 1st 08 02:58 PM
ROUNDing on a MAC - conversion error	Lokai	Excel Programming	2	June 30th 05 10:34 PM
Is this rounding error?	Ron Rosenfeld	Excel Programming	3	September 13th 04 05:56 PM
Rounding Error	Matthew W	Excel Programming	5	April 19th 04 10:11 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us