how to loose #VALUE!

[jbrodgers]

Hello ... again,
In a sheet I am working on, I have 3 cells whos display each depends on basic math... in cell 3, it ts display requires the displayed answers from the input of K cell, and one other cell (with math formula).
If either of the two cells are blank, I show #VALUE! ... according to the 'help' this is because of =J9/K9 (one of those being a zero) This is all well and good, all the math(s) work. I just want to HIDE the #VALUE! being displayed... any Ideas? Here is how I have them set up...

cell I9 =IF(D9=0,"",D9/E9)
cell J9 =IF(G9=0,"",G9*I9)
cell L9 =J9/K9

Suggestions please

 

[VoG]

Try in L9

=IF(AND(I9<>"",J9<>""),J9/K9,"")

 

[jbrodgers]

It worked... Thx