Show Empty 1

[jatolo]

=IF(E9>E10,"A",IF(E9<E10,"B",IF(E9=E10,"C")))
Can someone help me...
As you see if there any score the results are A , B, C... now if there's no scores I'd like to show empty cell....
Thanks for your help!!!

 

[Lilliabeth]

You might want to consider a VLOOKUP instead, but here it is an an IF

=IF(E9=0,"",IF(E9>E10,"A",IF(E9<E10,"B","C")))


--Lilliabeth

 

[jatolo]

Thank very much...but did NOT work, 0 0 is an score
I changed it to
=IF(E9="","",IF(E9>E10,"A",IF(E9<E10,"B","C")))
... and it show C...
thanks again ...

 

[Lilliabeth]

Opps, sorry about that. It is early here, still on my first cup.

I usually use ISBLANK,and should have posted:


=IF(ISBLANK(E9),"",IF(E9>E10,"A",IF(E9<E10,"B","C")))

--Lilliabeth

 

[jatolo]

Sorry...
If I leave E9 and E10 blank still show C...

=IF(ISBLANK(E9),"",IF(E9>E10,"A",IF(E9<E10,"B","C")))

 

[Lilliabeth]

You didn't say what to do if E9 has data but E10 is blank, so I guessed. This will make the cell look empty if EITHER E9 or E10 is blank.

=IF(OR(ISBLANK(E9),ISBLANK(E10)),"",IF(E9>E10,"A",IF(E9<E10,"B","C")))

--Lilliabeth

 

[jatolo]

A Inglaterra 1 A Inglaterra 0
B U.S.A. 0 A B U.S.A. 1 B
C TIED C TIED

A Inglaterra 0 A Inglaterra BLANK
B U.S.A. 0 C B U.S.A. BLANK BLANK
C TIED C TIED BLANK

=IF(E9>E10,"A",IF(E9<E10,"B",IF(E9=E10,"C")))

This is what I'm looking for...with my formula works perfect, BUT the last option is giving a BIG HEADACHE!!!
Thanks...

 

[Lilliabeth]

Did you try the formula I just posted?


--Lilliabeth

 

[Lilliabeth]

(If either E9 or E10 is blank, then produce an empty string.
If E9>E10 then A, otherwise
If E9<E10 then B, otherwise C)

--Lilliabeth

 

[jatolo]

Yes I tried
=IF(OR(ISBLANK(E9),ISBLANK(E10)),"",IF(E9>E10,"A",IF(E9<E10,"B","C")))...
and still shows C...
thanks,,,

 

[Lilliabeth]

For What? It still shows C for WHAT?

Under WHAT condition does it show C incorrectly?



--Lilliabeth

 

[Lilliabeth]

I am betting you think E9 and E10 are empty but they are not. Select E9 and press the Delete key. Then select E10 and press the Delete key.
See the formula work when E9 and E10 are empty?

--Lilliabeth

 

[Lilliabeth]

=IF(OR(ISNUMBER(E10)=FALSE,ISNUMBER(E11)=FALSE),"",IF(E10>E11,"A",IF(E10<E11,"B","C")))

--Lilliabeth

 

[Lilliabeth]

of course, the cell addresses should have been E9 and E10.

--Lilliabeth

 

[jatolo]

Dear...Lilliabeth
THANKS FOR YOUR HELP!!!
IT WORKS PERFERCT...
MMMM.. NEXT ONE IT HARDER i GUESS...
BYE

 

[Lilliabeth]

Yay! Bye!

--Lilliabeth