IF Function (I THINK) Excel 2003

  • Thread starter Thread starter Bons
  • Start date Start date
B

Bons

I had an old spread sheet I created in 2003 and recently transferred to 2007.
My formulas are no longer working and I'm trying to figure out how I created
it in the first place.

It's pretty basic---all I want is for it to read: In cell C2 --if B2= W
C2 should be 2 if B2= L C2 should be .5.

I play online Backgammon and keep track of my wins/losses this way. I
believe I used the IF function, but tried to figure it out all weekend and
couldnt come up with anything that worked...I know it's something really
easy---just can't remember what it is. Thanks for any help you can give me
on this!
 
One way:

C2: =IF(B2="W",2,IF(B2="L",0.5,""))

or, if B2 must have either W or L:

C2: =IF(B2="W",2,0.5)

or, if B2 must be either blank, W, or L:

C2: =IF(B2="","",IF(B2="W",2,0.5))
 
THANKS so much for the Very SPeedy answer!!! It worked like a charm! And
from your answer was able to figure out how I should have done it with the
Insert Function. Thanks again!!! I Love this site!!!
 
Thanks, JE!!! I really appreciate being able to come here to get answers
from other users!!!
 

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

IF Function 3
IF function help 4
Formula for elapsed time 3
function update 3
Calculating the Count of Monthly Gains/Losses 3
Excel Functions 1
Complicated If Statement - I Think! 5
Increasing number depending on input 4

Back
Top