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