letters in IF formulas?

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

John

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Letters in IF formulas 3
letters in IF formulas? 0
Keep First Letters, with exceptions 0
Merging from an Excel file with graphics 1
Problem with SET & REF function 0
VBA - exporting serial letters to single documents 0
Improving Macro That Keeps First Letter 0
Delete all data after a symbol in a field 0

Top