Thanks:  0
Likes:  0

1. 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
Hi James:
What is in cell C7
What is in cell J7
and are you sure cell H7=G7/C7

Now James, you have to slow down and follow everything very closely ... Excel is very picky on details -- it does what you ask it to do -- unfortunately it does not do what you want it to do.

Regards!
Yogi Anand

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

3. if g7 is empty than h7 will have a problem before j7 will!

4. 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
James: Change the formula to:

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

and tell me if that helps.

Regards!

Yogi

5. Hi Yogi,

With your last suggested formula it returns
-3% not the correct ans 175%?

James

6. the result you are getting is correct according to the figures you have already posted...

are you calculating correctly?

[ This Message was edited by: Qroozn on 2002-04-30 22:34 ]

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

In H7 enter:

=IF(C7,G7/C7,0)

In J7 enter:

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

I was hoping you were going to read my post,
it now works like it's supposed to.

James

## 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
•