On 2002-04-30 21:23, James wrote:
Hi again Yogi,
Cell F7 "0.03"
Cell G7 "5.45"
Cell H7=G7/C7 "0.011"
But when G7 is empty
Cell J7 is returning the #DIV/0!
Any thoughts
James
On 2002-04-30 21:44, James wrote:
Hi again Yogi,
Thanks for hanging in ther w/ me.
C7 is 500
J7 is =F7/H7-1
H7 is G7/C7
The correct ans. in J7 is 175%
What i'm trying to accomplish is simply if
G7 is empty then J7 does not show the #DIV/0!
Thats it
James