complicated formula

[Joann]

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

 

[Peo Sjoblom]

Not complicated but there are some holes in your post


=IF(Z10<0,"no order",IF(X10<0,AI10-AJ10,AS10))

what if Z10 or X10 are blank or 0?

--


Regards,


Peo Sjoblom

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Joann]

Well, I don't think that will happen....given the data that I have, I don't
see anywhere in which that is the case....I am dealing with order quantities
& it will always be either positive or negative...can you help?

 

[Joann]

ok, here is where I am....I have the fomula listed below.....

=IF(AC16<0,"NO ORDER",IF(AB16<0,AJ16-AK16+AT16+AU16,AU16))

AB is the column in which the result is either positive or no order. So in
this calculation, instead of calculating the equasion out
AJ16-AK16+AT16+AU16, it is just bringing back AU16....does that result of no
order have to do with this doing this?

 

[RobFJ]

I think this works - but depends on how you want to treat a zero. Formula
below assumes a negative number is classed as something less than zero

Hope this helps.

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