Hi There, I am currently using the following formula in cell BN4:

=IF((BN4>BO4),"H",IF((BN4=BO4),"D",IF((BN4<BO4),"A")))

What I am after achieving is BM4 to remain blank until data is entered into both BN4 and BO4. BM4 is to be blank when cells BN4 and BO4 are blank.

Due to the middle section of the formula I am using ,IF((BN4=BO4),"D", cell BM4 constantly shows 'D', because while cells BN4 and BO4 are blank it satisfies the middle section of the formula and returns 'D' as the answer.

Does anyone know of a solution to this head-scratcher?

Regards