Returning a blank cell if no values entered into Columns D or E

Good morning. I am using the following formula to return a specific value in Column F of my workbook. It works perfectly as is with the exception of needing Column F to remain BLANK if the corresponding cells in Columns D & E are also blank (i.e. D21=BLANK, E21=BLANK then F21=BLANK).

Here's the formula I'm working with:

Please Login or Register  to view this content.

I've attached a sample workbook to this thread which contains the table and the above formula. Your suggestions are appreciated. Thanks.

Matthew

Kapar,

Thanks for offering up a solution. It works great....just as hoped. I'm relatively new to Excel so I was wondering if you wouldn't mind explaining a little bit about how the formula works when IF(AND(D2="",E2=""),"", is added to the formula? Thanks again.

Matthew

Kaper,

Thanks for the explanation. I played with the workbook this weekend a bit and the formula is holding up nicely. Thanks again for offering spot on help.

Matthew

p.s. I finally go your name correct in this post!