Hiding #DIV/0! when a formula does not have anything yet to calculate?

[jonvanwyk]

I have the following formula in a worksheet that uses data entered into cells found in another worksheet within the same workbook:

=SUM('1-1'!C4/'1-1'!B4)-1

Since no one has entered data into the cells in the other worksheet, the formula is returning a result of #DIV/0! instead of remaining blank. How do I make it so these cells are blank until data is entered into the other worksheet calculating a real result?

[daddylonglegs]

You don't need SUM function, try like this

=IF(COUNT('1-1'!B4:C4)=2,'1-1'!C4/'1-1'!B4-1,"")

[scottylad2]

=IF(or('1-1'!C4="",1-1'!B4=""),"",SUM('1-1'!C4/'1-1'!B4)-1)

think that should do it

[jonvanwyk]

@SCOTTY: Your solution worked better. Thank you both.