Make a cell blank if the product does not fall between -9.99% and 9.99%

[zack.harmon]

I would like to make a cell blank if the product of H12/F12 is equal to or falls within the range of -9.99% and 9.99%. If the product falls outside of that range I would like the product to display in that same cell. Also in some instances I will have a Zero in either cell H12 and/or F12 and I do not want #DIV/0! to appear. This formula will span across 55 tabs in a workbook.

For added clarification: H12=-2,838 and F12=6,814 which has a product of -42% so I would like that product to display in cell I12. However in other circumstances such as:

H12=4,995 and F12=873,236 my product is 1% and since that falls in between the threshold of -9.99% and 9.99% I want a blank cell to show in I12. Thank yu for any help.

 

[BenMiller]

Try

=IF(F12=0,"",IF((ABS(H12/F12)<=0.0999)*(H12<>0),"",H12/F12))

 

[zack.harmon]

Ben, that seems to work well, however there is a scenario that still displays a product of 0% in instances where Col. H has a 0 value. Btw thank you for your quick and dedicated reply the first go around.

 

[BenMiller]

Try

=IF((F12=0)+(H12=0),"",IF((ABS(H12/F12)<=0.0999)*(H12<>0),"",H12/F12))

 

[zack.harmon]

Ben I wanted to check all documents before I posted but yes your solution worked. Thank you once again.

 

[BenMiller]

No problem Glad I could help Appreciate the feedback!