R
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
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