Blank cell if adjacent cell is blank

[colin5392]

I am already using the formula =IF(TODAY()>L50,"Review Required",IF(TODAY()>L50-180,"Review Pending","Current")) in cell M50, but is there is no data contained within L50, how do I get it to show nothing in M50, i.e. leave the cell blank?

Thanks, in advance

 

[Tetra201]

Try this:

=IF(ISNUMBER(L50),IF(TODAY()>L50,"Review Required",IF(TODAY()>L50-180,"Review Pending","Current")),"")