Assigning cells a value

  • Thread starter Thread starter acorbalis
  • Start date Start date
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
 
"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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Randomly assigning Data 1
Include a value from one cell within text of another cell. 2
Help with a macro 4
Split Cell Range into Multiple Cells 1
Time Format Autofill 1
sum if 4
Copy Value of Active cell and 25 rows above to a diff worksheet 4
Browse For a File or Path and enter in a cell 5

Back
Top