software

I am trying to use this if statement:
IF((J8*J25-J10*J25)lt;=0,quot;0quot;,IF(J8*J25-J10*J25gt;0,quot;J8*J25-J10*J25quot;)), the
problem is I can not figure out how to tell it if the answer is greater than
0, put in the number and not J8*J25-J10*J25, can anyone help?

Remove the quotes form the ELSE argument.

=IF((J8*J25-J10*J25)lt;=0,quot;0quot;,IF(J8*J25-J10*J25gt;0,J8*J25-J10*J25))--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
quot;LAybarquot; gt; wrote in message
...
gt;I am trying to use this if statement:
gt; IF((J8*J25-J10*J25)lt;=0,quot;0quot;,IF(J8*J25-J10*J25gt;0,quot;J8*J25-J10*J25quot;)),
gt; the
gt; problem is I can not figure out how to tell it if the answer is
gt; greater than
gt; 0, put in the number and not J8*J25-J10*J25, can anyone help?
Chip,
Thank you, I have been staring at this for so long, I just could not see
what the problem was!!!

quot;Chip Pearsonquot; wrote:

gt; Remove the quotes form the ELSE argument.
gt;
gt; =IF((J8*J25-J10*J25)lt;=0,quot;0quot;,IF(J8*J25-J10*J25gt;0,J8*J25-J10*J25))
gt;
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt;
gt; quot;LAybarquot; gt; wrote in message
gt; ...
gt; gt;I am trying to use this if statement:
gt; gt; IF((J8*J25-J10*J25)lt;=0,quot;0quot;,IF(J8*J25-J10*J25gt;0,quot;J8*J25-J10*J25quot;)),
gt; gt; the
gt; gt; problem is I can not figure out how to tell it if the answer is
gt; gt; greater than
gt; gt; 0, put in the number and not J8*J25-J10*J25, can anyone help?
gt;
gt;
gt;

=IF((J8*J25-J10*J25)lt;=0, 0, (J8*J25-J10*J25))
Syntax of IF: IF(test, result_when_test_TRUE, result_when_test_FALSE)

Your formula could be simplified to
=IF((J8-J10)*J25lt;=0, 0, (J8-J10)*J25)

Also you could abandon IF and use
(J8-J10)*J25)*((J8-J10)*J25)gt;0)
The Boolean expression (J8-J10)*J25)gt;0 will evaluate to TRUE or FALSE which,
when part of an arithmetic expression, are treated as 1 and 0, respectively.

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

quot;LAybarquot; gt; wrote in message
...
gt;I am trying to use this if statement:
gt; IF((J8*J25-J10*J25)lt;=0,quot;0quot;,IF(J8*J25-J10*J25gt;0,quot;J8*J25-J10*J25quot;)), the
gt; problem is I can not figure out how to tell it if the answer is greater
gt; than
gt; 0, put in the number and not J8*J25-J10*J25, can anyone help?
By putting text between quot;, the output willbe exactly as typed. remove the quot;
and you will get the result. so try :

IF((J8*J25-J10*J25)lt;=0,quot;0quot;,IF(J8*J25-J10*J25gt;0,J8*J25-J10*J25))
quot;LAybarquot; wrote:

gt; I am trying to use this if statement:
gt; IF((J8*J25-J10*J25)lt;=0,quot;0quot;,IF(J8*J25-J10*J25gt;0,quot;J8*J25-J10*J25quot;)), the
gt; problem is I can not figure out how to tell it if the answer is greater than
gt; 0, put in the number and not J8*J25-J10*J25, can anyone help?