Have values posted in column D that I do not want to have there.

Hello,

Looking for help with this.

If I do not have a value in column B or C I would like the corresponding cell in column D to be blank.
How do I do that?

Work book attached.

Thank you,
Rich

Hi,

a first attempt using a condition

in D1

=IF(OR(B1="",C1=""),"",SUMPRODUCT((C1>C$1:C$10)/(COUNTIF(C$1:C$10,C$1:C$10&"")))+1)

or if you'd need a blank cell when B and C are blank

=IF(AND(B1="",C1=""),"",SUMPRODUCT((C1>C$1:C$10)/(COUNTIF(C$1:C$10,C$1:C$10&"")))+1)

Regards