Return cell, if cell is blank (ignorer formula in blank cell) return cell X

[twrtleduck]

I want cell X to return cell Y but if cell Y is blank, I want cell X to return cell Z. Cell Y haves a formula in it so it isn't registering a blank cell to cell X. How do I get cell X to read the cell as blank when the formula in cell Y is returning a blank cell?

[Richard Buttrey]

Hi,

Maybe in G5

=IF(F5=0,F6,F5)

and G6

=IF(F6=0,0,F6)

[twrtleduck]

There is no G6 I want either/or f cells to return into G5 but this gave me an idea and seems to be working. I have the f cells formulas return 0 instead of blank. Now I can use =IF(F5="0",F6,F5)