Require cell to be zero if adjacent cell is zero, & copy a cell if adjacent cell is blank

Hi,

I am looking for a formula by which the value in the target cell will be zero if the adjacent cell is zero, and a value from another cell will be copied if the adjacent cell is blank.
For example, in the attached sheet, I require cell G3 to be zero if the user inputs a value of zero in cell F3, and G3 to display the value of cell E3 if the user leaves F3 blank. Please note that I will be using conditional formatting using icon sets to display an icon in F3 when the user keys in zero in this cell.

I would greatly appreciate any help with this. Thank you.

Welcome to the forum!

Try this:

=IF(F3="",E3,F3)

Thank you very much for your reply and for the welcome! In between my posting of my question, and seeing your reply, however, I managed to get hold of the formula: =IF(ISBLANK(F5),E5, (F5))

I do appreciate your prompt reply

You're welcome! Be aware, though, that the ISBLANK function will only work with truly blank cells, not those whose apparent blankness is the result of a formula.