IF, and, or statements combined
The second one will do it all...
=IF(A8=0,0,100*A7/A8)
--
Rick (MVP - Excel)
"lite" wrote in message ...
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???
|