IF, and, or statements combined

[lite]

I have this formula where both rows is zero, but I do not want the error
Div#/0 or #value instead I want to display a zero.
I have:
IF(a7=0,0,100*(a7/a8))
IF(a8=0,0,100*(a7/a8))
Now I want to combine both to use if a7 or a8 are equal to zero, then give a
zero. otherwise give me the value ( which in some cases is a positive value
or percent)
any ideas???

 

[Rick Rothstein]

The second one will do it all...

=IF(A8=0,0,100*A7/A8)