Making a code letter = a # in diff column

  • Thread starter Thread starter Shap
  • Start date Start date
S

Shap

Here is what I am wondering. I have created a log of hours for my bus.
In Column *A* I have used three different letters (F,R,L) to represent
a number of hours I have worked on something. How can I make excel do a
function like this example. If column *A* has the letter "F" in it, it
automatically puts "10" in column *G*? The thing is I need it to have
about 3 different "if"s, ie; If F=10, if L=5, ifR=3

Any help would be great!!

Thanks!:confused:
 
Shap,

In column G put
=IF(A1="F", 10, IF(A1="L", 5, IF(A1="R",3,"Bad Code")))
drag down

Logic
If A1 is "F" G1 = 10
IF A1 is not "F"
IF A1 is "L" G1 = 5
IF A1 is not "L"
IF A1 is "R" G1 = 3
IF A1 is not "R" G1 = "Bad Code"

Dan E
 
Back
Top