Thanks:  0
Likes:  0

1. 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

2. 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
Hi James :
It is not clear what are the arguments in your second formula ... Did you mean your second formula to be ...

=IF((H23-1)=0,0,F23/(H23-1))

Please post back if it works for you ... otherwise explain a little further and let us take it from there!

3. Very good Yogi,

This seems to do it:

=If((H7-1)=0,0,F7/H7-1)

Thanks
James

4. No, it's still returning the #DIV/0! ???

James

5. No, it's still returning the #DIV/0! ???

James

6. 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
Hi James:
Once more slow down and be patient ... I think you meant to post the following formula:
=If((H7-1)=0,0,F7/(H7-1))

Regards!

Yogi Anand

7. Yogi...
I think you pinned that one on the head!
well done!

8. On 2002-04-30 21:15, Qroozn wrote:
Yogi...
I think you pinned that one on the head!
well done!
Hi Qroozn:
I got the drift of what you were trying to say to gideon, so on tonite's watch you be the tough guy and I'll be the softie.

Regards!

Yogi Anand

9. 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

10. =If(Or((H7-1)=0,g7=0),0,F7/(H7-1))

User Tag List

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•