Formula that leaves cell blank until formula calculated

[blandreth]

What can I add to the following formula that will leave the cell blank until the formula is calculated - so this doesn't show as the result: #DIV/0!

Simple formula: =(B17+C17)/E17

Formula is in cell H17 which I want to remain blank until the formula can be calculated, then the result of the formula would show in H17

Thanks!

 

[Joe4]

So, what you are waiting for is a value in E17, right?

Then try:

=IF(E17 <> 0,[COLOR=#333333](B17+C17)/E17,"")
[/COLOR]

 

[blandreth]

Perfect. Thank you so much!!

 

[Joe4]

You are welcome.