Blank unless another cell is populated than a formula is applied

**greenham** · 05-14-2012, 12:42 PM

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

**tigeravatar** · 05-14-2012, 02:22 PM

greenham,

Welcome to the forum!
Generally speaking, you would use an IF statement, and ="" to check for blank, like this:

=IF(OR(F2="",K2=""),"",your_formula_here)

Blank unless another cell is populated than a formula is applied

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Blank unless another cell is populated than a formula is applied

Re: Blank unless another cell is populated than a formula is applied

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions