if- then question

  • Thread starter Thread starter bubba1965
  • Start date Start date
B

bubba1965

Is it possible to compare two rows and then based on the value, assign
a character to occupy and adjacent column in the same row.

For example, I want to compare all of the numbers in column B, with th
numbers in column D, if B is greater than D, I want to put the lette
"W" in the adjacent column (in the same row). If B is less than D,
want to put the letter "L" in the adjacent column.

Is this possible
 
Hi
enter the following in the adjacent row (lets say in column E, cell E1)
=IF(B1>D1,"W",IF(B1<D1,"L","equal")
 
??

C1: =IF(B1>D1,"W",IFN1<D1,"L",""))

and copy down

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi ,please try this if i understood you well :


If (B1>D1;"W";"L") and drag your formula in the cells where you nee
tha
 
Bob said:
??

C1: =IF(B1>D1,"W",IFN1<D1,"L",""))

and copy down
Click to expand...

Bob
I think it's getting late for both of us :-)
I missed the closing parenthesis and an opening one.

For the OP try
C1: =IF(B1>D1,"W",IF(B1<D1,"L",""))
 
If (B1>D1;"W";"L")

I guess I need to if statements if that is possible.

If B1>D1 then W
If B1<D1 then L

So can I use this formula?

If (B1>D1;"W")
If (B1<D1;"L")
 
But you don't seem to allow B1 to be equal to D1. If it cannot be equal
OK. Otherwise you will have to decide what to do.

Al
 
Spellchecker doesn't catch that. My excuse is the red wine in my left hand
(don't tell Norman, but it is Australian!)

Bob
 
So you only need the equal if the numbers may be equal?

These are basketball scores, so they will never be equal - so can
leave equal off the formul
 
Bob said:
Spellchecker doesn't catch that. My excuse is the red wine in my left
hand (don't tell Norman, but it is Australian!)

Bob
Click to expand...

Sound delicious (a Shiraz maybe?) and excuse fully accepted :-)
 
Yes: you only need the equal if the scores can be eqaul.
Are you sure there can never be a draw in basketball? If you are (I
don't know the rules but maybe they play to a finish, or something) OK.
If you only believe they can't be equal, then better safe than sorry:
it's easy to take out the insurance.

Alf
 
Hi Bob!

Re: "don't tell Norman, but it is Australian!"

Where's mine!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Jacob's Grenache-Shiraz - good spot.

Norman, yours is on my kitchen table.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Valpolicella ...uuumh. Envy over here!

Just don't tell me you are rounding off with a 25 year old Macallan.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Bob said:
Valpolicella ...uuumh. Envy over here!

Just don't tell me you are rounding off with a 25 year old Macallan.
Click to expand...

No not this evening <vbg>
I 'have' to test this wine as we're having a little private wine
tasting 'competition' this weekend :-)
 
Hi Bob!

Thanks for the thought.

Nice little Barolla would go down very well right now but I'll settle
for Jacobs Creek. I think our vintners tended to copy Italians rather
than Germans.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Bob!

Thanks for the thought.

Nice little Barolla would go down very well right now but I'll settle
for Jacobs Creek. I think our vintners tended to copy Italians rather
than Germans.
Click to expand...

and be glad they do :-)
There is no such thing as a good German red wine (IMHO). Though we have
some nice white wines :-)
 
Back
Top