LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default How to Limit Cell Values to Multiple of 10?

I'm creating an excel survey, and for each cell in the survey, I want
to ensure that users can only enter a value that is a multiple of 10
(E.g. 10, 20, 50).

Other than creating a drop down with all the multiples of 10, is there
any other way to do this?

Thanks!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
How do I Auto-Filter with multiple values in a cell in Excel? Burghthing Excel Discussion (Misc queries) 2 November 23rd 05 04:41 PM
a unique cell value returns multiple cell values from another shee grflded Excel Worksheet Functions 0 September 25th 05 04:21 AM
How to sum the values of a single cell from multiple worksheets Ratman Excel Worksheet Functions 3 September 20th 05 06:35 PM
Cell values based upon multiple conditions Ryan M via OfficeKB.com New Users to Excel 2 July 19th 05 02:10 AM
Splitting multiple cell contents containing values at end Syns Excel Worksheet Functions 2 May 24th 05 04:24 PM


All times are GMT +1. The time now is 02:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"