Bernard said:
From Help in Excel 2007 but Excel 2003 works the same way:
Restrict data entry to a decimal number within limits
Select one or more cells to validate.
On the Data tab, in the Data Tools group, click Data Validation.
In the Data Validation dialog box, click the Settings tab.
In the Allow box, select Decimal.
In the Data box, select the type of restriction that you want. For
example, to set upper and lower limits, select between.
Enter the minimum, maximum, or specific value to allow. You can also enter
a formula that returns a number value.
Hi Bernard,
Thanks for the Data Validation help.
Unfortunately I think I'm going to need spoon-feeding on this one :-(
I followed your instructions, highlighted the range of cells A1:B21 and
selected Data Validation / Settings / Allow: Decimal / Data: Between.
However, I'm not sure how to write the formula for the 'Minimum' and
'Maximum' fields.
It is the sum of the data in cells A1:B21 that has to be between -24 and 24.
How do I write the formula so that the sum of cells A1:B21 is checked
against the limits -24 to 24?
I've tried a few variations of:
=SUM(A1:B21).... but the formula doesn't give the correct results.
I assume I understood you correctly that formulae can be entered in the
'Minimum' and 'Maximum' fields? Or were you referring to the 'Custom'
formula field?
Regards,