Blank unless another cell is populated than a formula is applied

I just found your site... I am a novice Excel user, and spent the whole morning looking at various threads.. I hope you guys/gals can help me.


As you can see from this image, without the cells (C2,D2,E2 Optimistic, Realistic, Pessimistic) populated, cell (F2 3 point estimate) will not calculate and the rest of the sheet turns to 0.0 and if cell (K2 Start Date) isn't populated than all the dates turn to 01/00/00

How can I get the rest of the cells to show nothing unless F2 (3 point Estimate) and K2 (Start Date) is populated, AND if they are apply the formula contained in the cells?


excel 2010.JPG