Spreadsheet validation

Posted to microsoft.public.excel.programming

quartz[_2_] quartz[_2_] is offline

external usenet poster

Posts: 441

Spreadsheet validation

Is there a way to set column "D" on a sheet to only accept (or automatically
round) a value in 0.50 increments?

Examples:

25.5 < ok
100 < ok
18.50 < ok
0.5 < ok
25.25 < invalid
35.3 < invalid

How can I do this?

Thanks much in advance

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
Data Validation On A Cells With Data From A Different Spreadsheet	Nat Govender	Excel Discussion (Misc queries)	6	December 9th 08 05:23 PM
Validation - removal of over an entire spreadsheet	Roger[_3_]	Excel Discussion (Misc queries)	2	July 26th 07 03:41 AM
Validation (Drop down list vs simple text length validation)	Bob Phillips[_6_]	Excel Programming	2	April 27th 04 07:47 PM
Validation (Drop down list vs simple text length validation)	Jason Morin[_2_]	Excel Programming	1	April 27th 04 04:56 PM
Validation (Drop down list vs simple text length validation)	Pete McCosh	Excel Programming	0	April 27th 04 03:49 PM

All times are GMT +1. The time now is 12:23 AM.

Menu

About Us