#DIV/0! displays in box (don't want to show/print)

[FragaGeddon]

Basically I have a formula like this: =SUM(J7/L7)
......K7 will display the info as a percentage.
When there is no data in L7 it displays #DIV/0!.
When something is entered in L7 and nothing in J7 it displays 0.00.
Basically I want to either hide the 0.00 and #DIV/0! from display and/or printing.
The really more important thing is to not have that cell print if there is no value.

Thanks for your help.

 

[T. Valko]

Basically I have a formula like this: =SUM(J7/L7)
......K7 will display the info as a percentage.
When there is no data in L7 it displays #DIV/0!.
When something is entered in L7 and nothing in J7 it displays 0.00.
Basically I want to either hide the 0.00 and #DIV/0! from display and/or printing.
The really more important thing is to not have that cell print if there is no value.

Thanks for your help.

Try this...

=IF(OR(J7="",L7=""),"",J7/L7)

 

[FragaGeddon]

Try this...

=IF(OR(J7="",L7=""),"",J7/L7)

Thanks, that works. +1

 

[T. Valko]

Thanks, that works. +1

You're welcome. Thanks for the feedback!

 

[FragaGeddon]

Just need a bit more help with this.
Adding cells C5 to C11. if there is no value, then want it to display nothing.
I've tried:
=IF(OR(C5="",C6="",C7="",C8="",C9="",C10="",C11=""),"",C5:C11)
Which I believe says if any of those cells have nothing, then display nothing.
So i tried IF(OR(C5="":C11=""),"",C5:C11) which doesn't work either.

 

[FragaGeddon]

I also have this in cell D12:
=IF(OR(C12=""),"",C12/Y12)
but the value in C12 is $0.00, which is really the main cell I'm worried about than the one above.
I tried =IF(OR(C12="$0.00"),"",C12/Y12) but that doesn't work.

 

[T. Valko]

Just need a bit more help with this.
Adding cells C5 to C11. if there is no value, then want it to display nothing.
I've tried:
=IF(OR(C5="",C6="",C7="",C8="",C9="",C10="",C11=""),"",C5:C11)
Which I believe says if any of those cells have nothing, then display nothing.
So i tried IF(OR(C5="":C11=""),"",C5:C11) which doesn't work either.

I assume you want EVERY cell to have a number otherwise return blank?

=IF(COUNT(C5:C11)<6,"",SUM(C5:C11))

 

[FragaGeddon]

 

[FragaGeddon]

I assume you want EVERY cell to have a number otherwise return blank?

=IF(COUNT(C5:C11)<6,"",SUM(C5:C11))

Every number might not have a value. See my screenshot and you'll see. Thanks for your help. I'm more worried about the % column from displaying #DIV/0!

 

[Roli001]

Try this:

=IF(ISERROR(J7/K7),"",J7/K7)