Letters in IF formulas

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

 

[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

 

[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

 

[That One Guy]

I think you might be better off using data-validation and vlookup.

See http://www.contextures.com/xlDataVal01.html for data validation, and
http://office.microsoft.com/en-us/excel/HP052093351033.aspx for vlookup.

Regards,

That One Guy.