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.

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.

Formula question
 

Thank you very much. That worked great, but can I enter a validation
for a sum function? Thank you.