software

I don't think there are any problems in this quot;ifquot; statement, but it's not
returning any values; it just shows the entire formula in the cell.

=IF(E18lt;0,quot;=sum(c24-e17)-c17quot;,quot;=sum(c24-c17)quot;)

When I test the statements separately, they come back with a value just
fine. I even tried deleting the =sum in the formula thinking there should
only be one = sign at the beginning of the formula, but that didn't work. It
doesn't give me the #VALUE message either indicating something is wrong in
this formula. Any ideas??

Oh yeah....I'm using Office 2000.

By using quotes you're telling Excel to return a string or text, not a sum.
Use this instead

=IF(E18lt;0,sum(c24-e17)-c17,sum(c24-c17))quot;Shellackquot; wrote:

gt; I don't think there are any problems in this quot;ifquot; statement, but it's not
gt; returning any values; it just shows the entire formula in the cell.
gt;
gt; =IF(E18lt;0,quot;=sum(c24-e17)-c17quot;,quot;=sum(c24-c17)quot;)
gt;
gt; When I test the statements separately, they come back with a value just
gt; fine. I even tried deleting the =sum in the formula thinking there should
gt; only be one = sign at the beginning of the formula, but that didn't work. It
gt; doesn't give me the #VALUE message either indicating something is wrong in
gt; this formula. Any ideas??
gt;
gt; Oh yeah....I'm using Office 2000.

So that was the problem....Thank you!!

quot;Duke Careyquot; wrote:

gt; By using quotes you're telling Excel to return a string or text, not a sum.
gt; Use this instead
gt;
gt; =IF(E18lt;0,sum(c24-e17)-c17,sum(c24-c17))
gt;
gt;
gt; quot;Shellackquot; wrote:
gt;
gt; gt; I don't think there are any problems in this quot;ifquot; statement, but it's not
gt; gt; returning any values; it just shows the entire formula in the cell.
gt; gt;
gt; gt; =IF(E18lt;0,quot;=sum(c24-e17)-c17quot;,quot;=sum(c24-c17)quot;)
gt; gt;
gt; gt; When I test the statements separately, they come back with a value just
gt; gt; fine. I even tried deleting the =sum in the formula thinking there should
gt; gt; only be one = sign at the beginning of the formula, but that didn't work. It
gt; gt; doesn't give me the #VALUE message either indicating something is wrong in
gt; gt; this formula. Any ideas??
gt; gt;
gt; gt; Oh yeah....I'm using Office 2000.

Also, you do not need SUM to do simple arithmetic
=IF(E18lt;0,c24-e17-c17,c24-c17)

And IF is not really needed either
=(C24-E17)-C17*(E18lt;0)

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Shellackquot; gt; wrote in message
...
gt; So that was the problem....Thank you!!
gt;
gt; quot;Duke Careyquot; wrote:
gt;
gt;gt; By using quotes you're telling Excel to return a string or text, not a
gt;gt; sum.
gt;gt; Use this instead
gt;gt;
gt;gt; =IF(E18lt;0,sum(c24-e17)-c17,sum(c24-c17))
gt;gt;
gt;gt;
gt;gt; quot;Shellackquot; wrote:
gt;gt;
gt;gt; gt; I don't think there are any problems in this quot;ifquot; statement, but it's
gt;gt; gt; not
gt;gt; gt; returning any values; it just shows the entire formula in the cell.
gt;gt; gt;
gt;gt; gt; =IF(E18lt;0,quot;=sum(c24-e17)-c17quot;,quot;=sum(c24-c17)quot;)
gt;gt; gt;
gt;gt; gt; When I test the statements separately, they come back with a value just
gt;gt; gt; fine. I even tried deleting the =sum in the formula thinking there
gt;gt; gt; should
gt;gt; gt; only be one = sign at the beginning of the formula, but that didn't
gt;gt; gt; work. It
gt;gt; gt; doesn't give me the #VALUE message either indicating something is wrong
gt;gt; gt; in
gt;gt; gt; this formula. Any ideas??
gt;gt; gt;
gt;gt; gt; Oh yeah....I'm using Office 2000.