IF formula with "isblank" and "equal"

[Glenda Dalton]

I need a formula to find out the following: if D2=B2 return nothing; if D2 is different than B2, return D2; AND if #D2 is blank, return blank.

 

[Joe4]

Welcome to the Board!

Try:

=IF(OR(D2="",D2=B2),"",D2)

 

[Glenda Dalton]

That worked, perfectly! Thank you so much!!!!!!

 

[Joe4]

You are welcome.
Hopefully, it the formula makes sense to you.
If you have any questions about it, feel free to ask.