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???