letters in IF formulas?

  • Thread starter Thread starter drmcleod
  • Start date Start date
D

drmcleod

If the value in a cell is a letter, can that be used in an IF formula?

I am making a simple chore worksheet for my kids. Each chore (cell) is
represented by a letter. Also, each chore is worth a certain amount of money
(i.e. K chore is worth $1) I would like them to be able to enter in their
chore letter when it's completed and let the spread sheet enter and calculate
the amounts and running totals. Can this be done?

For example:

=IF(c7=K,1,IF(c7=X,2))
 
HI
No problem, type it this way =IF(A1="A",1,IF(A1="B",2,"")) adjust range to
your needs.
You can replace "" in the formula with anything you would like if the
conditions are not met.
HTH
John
 
Back
Top