Try:

=IF(Z10<=0,"No Order",IF(X10<=0,AI10-AJ10+AS10,AS10))

or the slightly shorter:

=IF(Z10<=0,"No Order",AS10+(AI10-AJ10)*(X10<=0))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Joann" wrote in message
...
I need help. I have a number in a cell. I want the formula to be the
following but i don't know how to write it or if it is possible. If the
value in Z10 is less than zero, then i want it to pull back the phrase "no
order". If this is not the case---if it is positive, then I want it to
look
at X10....if X10 is negative, then I want the result to be (AI10-AJ10) +
AS10. If X10 is positive, then I want the result to be AS10.

Can someone please help me??