IF Formula - Isn't returning Blank when I want

[tlc53]

Hi there,

I would like cell D310 to return blank, if cell B310 is blank. Both contain an if formula..

Cell B310
=IF(SUM(F310:G310)<>0,433,"")

Cell D310
=IF(N(B310)<>"",FYE_Date,"")

In this instance, both cells should be blank but cell D310 is returning the FYE Date.

Does anyone have any ideas to get around this please? Thank you!

 

[James006]

Hi,

Could you test following:

Cell D310
=IF(B310="","",FYE_Date)

Hope this will help

 

[tlc53]

Great, it works! Thank you!!

 

[James006]

You are welcome ...