Formula question

[dzahner]

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.

 

[Guest]

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

 

[dzahner]

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