If cell matches cell, do one thing, if no, do another. If matching cell is blank, do another.

[RodneyW]

This formula is in column W

=IF(E30=V30,"Y","N")

How do I modify it so that if cells in column V are empty, cells in W will be blank? Right now they show up as N.

Thanks in advance.

 

[samdthompson]

=IF(V30="","",IF(E30=V30,"Y","N"))

 

[RodneyW]

=IF(V30="","",IF(E30=V30,"Y","N"))

Worked perfect, thank you