Nested IF Statement Referencing Multiple Cells

Hello, I am trying to use a nested IF statement that references multiple cells. If a certain cell says YES, then I want the $ value in a specific cell. But if that cell is blank then I want the $ value in the cell above. Here is the formula I'm using: =IF(E33="YES",D39,IF(D39="",D38)). When cell D39 is blank i get 0.00, not the value in cell D38. Thanks in advance for your help!

What is in E33?

If "YES", you get value in D39

maybe this ...


=IF(E33="YES",IF(D39="",D38,D39))

Hi

What is the value required when E33 not YES or not blank.

Cheers

Sorry for not stating so earlier.

Cell E33 defaults to "Select an item" and has a dropdown with YES or NO. If NO is chosen then the cell where the formula is placed will show 0.00.

JohnTopley, Your suggestion worked! Thanks so much for your help!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.