On 2002-04-30 20:54, James wrote:
Hi group,
To avoid the #DIV/0! i use :
=If(C23=0,0,G23/C23) but it doesn't work with
=If(H23,0,0,F23/H23-1) i know the glitch is
with the minus 1 "H23-1" any ideas on how to get around this
thanks
James
On 2002-04-30 21:07, James wrote:
Very good Yogi,
This seems to do it:
=If((H7-1)=0,0,F7/H7-1)
Thanks
James
On 2002-04-30 21:15, Qroozn wrote:
Yogi...
I think you pinned that one on the head!
well done!