help with IF function to avoid #DIV/0! error

[scolex]

I have a formula that uses cells that are populated from a table.
Here is the formula =($A6*$E$3)/($J$3*$M$3*1056)
There are occasions where J3 is blank and I would like the formula to return a blank value.

 

[Jonmo1]

You could do

=IF($J$3="","",($A6*$E$3)/($J$3*$M$3*1056))

 

[Roxxien]

=iferror(($A6*$E$3)/($J$3*$M$3*1056),)

From what I read this is what you search.

 

[Aladin Akyurek]

You might want to use IFERROR here...

=IFERROR(($A6*$E$3)/($J$3*$M$3*1056),"")

 

[scolex]

Thanks for the reply but that didn't change the result I still get the #DIV/0! error.
I tried changing the value to 0 instead of blank thinking maybe that would work but no luck.
I am a complete novice so please bear with me.

 

[scolex]

You might want to use IFERROR here...

=IFERROR(($A6*$E$3)/($J$3*$M$3*1056),"")

That worked thank you