3 CELL FORMULA WITH 1 CELL is "YES"

[jaxs2009]

Excel 2007 I have been raking my brain on this because I did this once before on my own and just can not remember the step, need help - here we go

Formula in cell BD6 =IF(AY6="YES" then BD6 = AF6 - ALSO - IF cell AY6 is blank then BD6 remains blank

AF6 is a date formatted cell

 

[Michael M]

Try

=IF(AY6="YES",AF6,IF(AY6="",""))

 

[jtakw]

Hi,

Use this:

=IF(AY6<>"Yes","",AF6)

 

[jaxs2009]

It works great, thank you very much, I missed the "","" after AY6= at the end of the formula

 

[jaxs2009]

This works as well, thank you very much.

 

[jtakw]

It works great, thank you very much, I missed the "","" after AY6= at the end of the formula

Michael M is one of my favorite persons on here, but I must say, his formula will error out if AY6 is anything other than "Yes", result will be FALSE...

 

[Michael M]

@jtakw
I apperciate your comment....but unfortunately I am prone to my seniors moments, especially when I'm at work....