one more thing off this subject. I've got calculations adding up different
cells on the page giving a final grade. But I need the grade to be no lower
than 70.
here is my cell formula.
=IF(SUM(F19,Q19,F38,Q38,(F49:J49))0,SUM(F19,Q19,F 38,Q38,(F49:J49)),(""))

"OssieMac" wrote:

Hi Brian,

Try Data Validation.

Select F13:J13

xl2007 version: Data tab on ribbon-Data tools block-Data Validation

pre xl2007 versions: Menu item Data-Validation-

In allow field: Select Custom

Uncheck Ignore blanks

In Formula field: =COUNTA($F$13:$J$13)<2

This validation does not confirm that an X has been entered but it only
allows one of the cells to have an entry.
Regards,

OssieMac


"Brian" wrote:

I am making a spread sheet to be used for data entry. the data entered is an
"x" with in a column. But I only want to allow one cell from f13:j13 to be
entered
Ex f13 is unsat g13 in below ave h13 is average and so on so by puting an
"x" in f13 it totals down and I don't want a double entry within the range of
f13:j13