Remove the quotes form the ELSE argument.
=IF((J8*J25-J10*J25)<=0,"0",IF(J8*J25-J10*J250,J8*J25-J10*J25))
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"LAybar" wrote in message
...
I am trying to use this if statement:
IF((J8*J25-J10*J25)<=0,"0",IF(J8*J25-J10*J250,"J8*J25-J10*J25")),
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?