#value error in formula

hi all i have the below formula in cell H15, which converts a user entry in H12, at the moment when cell H12 has no data entered the #value error appears in cell H15, i know you can use IFERROR to hide this, but where would i put it in the formula so the cell H15 is blank until data is entered in cell H12

Please Login or Register  to view this content.

thanks

Scouse13

As Ali has shown, sometimes it's better to test specifically for what causes your error (H12 being blank)

But to use iferror instead, quoting your question

but where would i put it in the formula

You don't put it (iferror) in your existing formula...
Instead, you put your existing formula in IFERROR.

=IFERROR(yourexistingformula,"")

The disadvantage (or advantage depending on your point of view) of using iferror instead of what Ali did is that IFERROR will trap ALL errors, not just specifically the one caused when H12 is blank. That may or may not be a good thing.

Originally Posted by AliGW

Try this:

=IF(H12="","",IF(Data!L$9=0,IF(L15=0,0,ROUND($H12/((ROUND((1.0001506*J15)-0.0012202,Data!$H$5))*L15),0)),IF(Data!L$9>0,IF(N15=0,0,ROUND($H12/N15,0)))))

thaNks AliGW works a treat