Formula for Blank Cell

[tbones]

On the link here: Outcome C2 is decided by the values in A2 and B2. So if A2 is greater than B2 then it puts in a H in C2. If A2 and B2 are the same then it puts in D.if A2 is less than B2 then it puts in A . I am also asking it that if A2 or B2 is blank then it should leave C2 blank as well.
The formula I have put in does not seem to work so I am not sure what I am doing wrong. It will not leave the cell blank if there are not any values in A2 and B2 .
This the formulas I am using
=IF(A2>B2,"H",IF(A2=B2,"D",IF(A2>B2,"A","")))
Any Ideas what I am doing wrong?

 

[kevin9999]

Book1
	A	B	C
1
2	2	1	H
3	1	2	A
4	1	1	D
5
Sheet1

Cell Formulas
Range	Formula
C2:C5	C2	=IF(OR(A2="",B2=""),"",IF(A2>B2,"H",IF(A2=B2,"D",IF(A2<B2,"A"))))

 

[Peter_SSs]

Another way

23 06 24.xlsm
	A	B	C
1
2	2	1	H
3	1	2	A
4	1	1	D
5	4
6
7		3
tbones

Cell Formulas
Range	Formula
C2:C7	C2	=IF(COUNT(A2:B2)=2,MID("ADH",SIGN(A2-B2)+2,1),"")

 

[tbones]

Thank you both. I tried your one Kevin however it did not leave the cell blank if the other cells were blank. I also tried Peters one and that did the trick.
Thanks for the help

 

[Peter_SSs]

You're welcome. Glad we could help. Thanks for the follow-up.

BTW, Kevin's formula works for me as shown below. If it does not work for you then it would seem those blank cells are not actually blank. Perhaps they contain a space character?

23 06 24.xlsm
	A	B	C
1
2	2	1	H
3	1	2	A
4	1	1	D
5	4
6
7		3
tbones (2)

Cell Formulas
Range	Formula
C2:C7	C2	=IF(OR(A2="",B2=""),"",IF(A2>B2,"H",IF(A2=B2,"D",IF(A2<B2,"A"))))

 

[tbones]

You're welcome. Glad we could help. Thanks for the follow-up.

BTW, Kevin's formula works for me as shown below. If it does not work for you then it would seem those blank cells are not actually blank. Perhaps they contain a space character?

23 06 24.xlsm
	A	B	C
1
2	2	1	H
3	1	2	A
4	1	1	D
5	4
6
7		3
tbones (2)

Cell Formulas
Range	Formula
C2:C7	C2	=IF(OR(A2="",B2=""),"",IF(A2>B2,"H",IF(A2=B2,"D",IF(A2<B2,"A"))))

maybe that was it then. I will go back and take a look. Thank you...

 

[tbones]

Thank you both. I tried your one Kevin however it did not leave the cell blank if the other cells were blank. I also tried Peters one and that did the trick.
Thanks for the help

Apologies to Kevin, The one you gave works indeed. I did not leave the spaces blank as I put a space in each cell. Thank you once again that worked fine.