Letters in IF formulas

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

drmcleod

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

I am making a simple chore spreadsheet for my kids. In this sheet, each
chore is represented by a letter. (i.e. B=clean bedroom) Also, each chore
has a certain value amount with it (i.e. B=$1). I would like to be able to
have the kids enter in the chore letter when it's completed and have the
computer do all the calculations of amounts and totals.

Can this be done?

For example:

=IF(c7=B,1,IF(c7=K,2))
 
Hi
Stop re-posting, your messages 6 of them are posted plus you have an answer
on your first post.
Ignore the error message
John
 
HI
This is a second reply in case you are not seeing the first one
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