Letters in IF formulas

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))
 
J

John

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
 
J

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
 
Top