formula question

[James]

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

 

[Yogi Anand]

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.

So please answer the questions I asked you and we will take it from there.

Regards!
Yogi Anand

 

[James]

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

 

[Qroozn]

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

 

[Yogi Anand]

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

 

[James]

Hi Yogi,

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

James

 

[Qroozn]

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

are you calculating correctly?

please repost your values.
This message was edited by Qroozn on 2002-04-30 22:34

 

[Aladin Akyurek]

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)

Aladin

 

[James]

Thanks Aladin,

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

James