sum not working with excel formulas

[RichardO]

Hi all:

I need your help with the following:

In cell G5, I have a dollar amount of -$33.27. There are no formula
in this cell.

In cell H5, I have this formula:
=IF(A5="",0,IF(ISERROR(G5/($G$23-$F$3)*$F$3),0,G5/($G$23-$F$3)*$F$3))
The value in this cell is: 0, this is correct.

In cell I5, I have this formula:

=IF(H5<>0,G5+H5,0)

The value it is giving me is 0. This is not correct, it should b
giving me -$33.27

I have formatted both of these cells to number, but it is giving me
zero value, can anyone please help as to why I am getting thi
incorrect number?

Thanks agai

 

[Dave Peterson]

What's in A5, G23, F3?

I think I'd use some test cells to see how the formula evaluates.

=G5/($G$23-$F$3)*$F$3

Just to see if it returns an error.

 

[Trevor Shuttleworth]

Richard

=IF(H5<>0,G5+H5,0)

But you said H5 = 0 and this is correct = TRUE. So H5 <> 0 would be FALSE,
so you get 0. That is the last part of the IF condition. Am I missing
something ?

Regards

Trevor