Assigning cells a value

A

acorbalis

I'm creating a sheet that will be used for attendance. Is it posssibl
to put an "x" in a cell and have that "x' represent ".25"? How would
set up a large number of cells to do this? Any help would b
appreciated
 
M

Myrna Larson

"Represent" in what sense? Are you doing some sort of calculations on this column? If so, you
would have to design your formulas to "translate the "X" into the number 0.25, i.e. something
like this:

=SUM(A1:A500)+COUNTIF(A1:A500,"X")*.25
 
Top