Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula question
I would like to only be able to enter a number between 1 and 5 in
certain cells in a spreadsheet. Is there a way to do this? Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula question
Yes, you can use Data Validation.
Select your cell(s), then from the Data Menu, select "Validation..." Change the Allow value to "Whole Number" or "Decimal" depending on your needs. Then set your minimum and maximum values. 1 and 5 for your example. You can also, if you like, customize the error message that the user will receive if they enter an invalid number. HTH, Elkar " wrote: I would like to only be able to enter a number between 1 and 5 in certain cells in a spreadsheet. Is there a way to do this? Thank you. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula question
Thank you very much. That worked great, but can I enter a validation
for a sum function? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Question | Excel Discussion (Misc queries) | |||
Excel formula question | Excel Discussion (Misc queries) | |||
Formula Question | Excel Worksheet Functions | |||
I have a question regarding countif formula. | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |