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

Advertisements

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

Top