If IsBlank

[roo181]

Hi,

I've set this up to give the Win / Loss / Draw based on the home teams score. But if the teams have a bye, the scores will be blank so if G7 is blank, then I want I7 to be blank also.

2024 - Fixture Results.xlsx
	G	H	I
1	Home Score	Opposition Score	WIN/LOSS
2			DRAW
3	14	4	WIN
4	2	17	LOSS
5	7	32	LOSS
6	26	22	WIN
7			DRAW
Sheet1

Cell Formulas
Range	Formula
I2:I7	I2	=IF(G2>H2,"WIN",IF(G2<H2,"LOSS",IF(G2=H2,"DRAW",IF(ISBLANK(G2),"BLANK","NOT BLANK"))))

Thanks for your help

 

[Fluff]

How about

=IF(G2="","",CHOOSE(SIGN(G2-H2)+2,"LOSS","DRAW","WIN"))

 

[etaf]

h0w about
=IF(G2="","",IF(G2>H2,"WIN",IF(G2<H2,"LOSS",IF(G2=H2,"DRAW",""))))

 

[myall_blues]

=IF(ISBLANK(G4),"",IF(G4>H4,"WIN",IF(G4<H4,"LOSS",IF(G4=H4,"DRAW"))))

 

[roo181]

=IF(ISBLANK(G4),"",IF(G4>H4,"WIN",IF(G4<H4,"LOSS",IF(G4=H4,"DRAW"))))

Thanks to everyone for their quick responses.
I think I like this the best as it's using the Isblank function. I was almost there with the version I had before the one I posted.

 

[Fluff]

The ISBLANK function can sometimes cause problems, you are normally better off using something like G2=""

 

[etaf]

not applicable here
BUT remember if a formula is in a cell
like in H2
=IF(G2="","",1)
then isblank(H2) will give a false for a blank cell

Book8
	D	E	F	G	H	I	J
1				Home Score	Opposition Score	WIN/LOSS
2					FALSE
Sheet1

Cell Formulas
Range	Formula
G2	G2	=IF(D2="","",1)
H2	H2	=ISBLANK(G2)
I2	I2	=IF(G2="","",IF(G2>H2,"WIN",IF(G2<H2,"LOSS",IF(G2=H2,"DRAW",""))))
J2	J2	=IF(G2="","",IF(G2>H2,"WIN",IF(G2<H2,"LOSS",IF(G2=H2,"DRAW",""))))