IF formula to have a cell go to blank if adjacent cell is empty

Hi, in this case, I need a cell to go to blank, not 0, if adjacent cell is empty.

Thanks!

PS Screen pic should say "I need these cells to go to blank". : )

Hi, in the cells in the table I'm addressing, there are no INDIRECT references. From your message, it looks like you are working on the top table, if that is the case, you'll need to scroll down to the third table. You'll see that I have G50 active in the screen pic I've included, with the formula in the tool bar. Your formula is in the white text box. The formula I'm using based on your input works in terms of the correct calculation, but it has no effect on causing the cells to go to blank when the adjacent cell (F column) is blank. Your suggestion is needed! : )
Thanks!

Yay! Thanks so much, worked perfectly, no surprise to you I'm sure.
Actually, in regard to the INDIRECT use, I think I do need to use it, or something else... The reason is because it is the only way I now of, (and I searched long and hard to find something that would work) is I needed to reference to a cell location that would not follow the default behavior of Excel when the cell being referred to is moved, as is the case =A1. I learned through the form that INDIRECT is volatile, but the only two pages affected by it are the two I sent you. So far, it seems to calculate fine (speed wise).

I've been using Excel extensively for years, but never needed to get into complex formulas until this project. So, on that note, I was wondering if you would do me a favor. You may be familiar with the snowball debt reduction method, the form I built off of to create the "T1 Calculator" sheet" was a free download. I have modified it extensively, and for the most part works well, though I did have to modify the interest calculation formula for it was off a bit (which may be another weakness of the original formula).

The problem with the Calculator page, is it is fomulated to only calculate correctly if a lower balance is paid off before a higher balance, thus you have to always place the lower balances above the higher ones, which is, the snowball method, however, there may be times people don't want to do that, the main reason being that if a creditor has a much higher APR, it makes more sense (in most cases) to pay that creditor off first.

If you feel like checking this out, you can do the following. On the Debt form page, overwrite the balance as follows: Creditor 2 $3000, Creditors 3 & 4 $1,000. You will see that the months to pay column shows Creditor 3 being paid off before Creditors 3 & 4. Also, the months to pay will not be accurate. To see why, you can click on the Calculator page tab, or click the little hand link for Creditor 3, you will see the weakness (limitation of the formula) for the min. payments for creditor 3, 4 & 5 all go up before Creditor 2 is paid off, which is what I would like to figure out how to fix. Perhaps you could take a look and see how difficult you think this would be. I don't have enough experience to know. Feels like it would be complex, but you're a Guru! Certainly it will need some more IFs : )

Just a request would value your opinion.

Thanks again so much for your help!
Bryan