Formula that leaves cell blank until formula calculated

blandreth

Board Regular
Joined
Jan 18, 2018
Messages
52
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!
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,432
Office Version
  1. 365
Platform
  1. Windows
So, what you are waiting for is a value in E17, right?

Then try:
Code:
=IF(E17 <> 0,[COLOR=#333333](B17+C17)/E17,"")
[/COLOR]
 
Last edited:

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,432
Office Version
  1. 365
Platform
  1. Windows
You are welcome.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,655
Messages
5,524,124
Members
409,561
Latest member
ay123

This Week's Hot Topics

Top