Formula Error

[Guest]

Hi Someone Help me please

IF(L3=M3+(N3=900),N3,"Backorder", IF(l3<>m3+(n3=900,"Future Order No Stock
Available",N3)
I keep getting the message the formula you typed contains an error, I 've
been lookibg at it for the past 1/2 hour and I don't see it.

 

[RagDyer]

Could you put your formula into just words?

An explanation of your intentions might clear up all the ambiguities your
"formula" contains.

 

[RagDyer]

Could you put your formula into just words?

An explanation of your intentions might clear up all the ambiguities your
"formula" contains.

 

[Guest]

If statement format is (3 parameters)

IF(Conditional Test, Condition is True, Condition is False)

Your IF statement has 4 parameters (with the 4th being another IF statement).

If the condition is False, do you want "Backorder" or "Future Order No Stock
Available". You could have another IF statement, but it is pointless to test
for L3<>M3+(N3=900). Since the IF statement is processing the 3rd parameter
(the False parameter of L3=M3+(N3=900)), you already know L3<>M3+(N3=900) is
true.


=IF(L3=M3+(N3=900), N3, "Backorder")

OR

=IF(L3=M3+(N3=900), N3, "Future Order No Stock Available")

 

[Guest]

If statement format is (3 parameters)

IF(Conditional Test, Condition is True, Condition is False)

Your IF statement has 4 parameters (with the 4th being another IF statement).

If the condition is False, do you want "Backorder" or "Future Order No Stock
Available". You could have another IF statement, but it is pointless to test
for L3<>M3+(N3=900). Since the IF statement is processing the 3rd parameter
(the False parameter of L3=M3+(N3=900)), you already know L3<>M3+(N3=900) is
true.


=IF(L3=M3+(N3=900), N3, "Backorder")

OR

=IF(L3=M3+(N3=900), N3, "Future Order No Stock Available")

 

[Guest]

Thanks this should all be one formula . here it goes
if order date equals pick up date and status equals 750 or 800 then show
word Backorder if not show whatever status number is in the cell. else if
order date does not equal pick up date and status is 500 show words future
order, if not show whatever status number is in the cell , else if order date
does not equal pick up date and status is 900 show words stock available if
not show status on the cell .

 

[Guest]

Thanks this should all be one formula . here it goes
if order date equals pick up date and status equals 750 or 800 then show
word Backorder if not show whatever status number is in the cell. else if
order date does not equal pick up date and status is 500 show words future
order, if not show whatever status number is in the cell , else if order date
does not equal pick up date and status is 900 show words stock available if
not show status on the cell .

 

[RagDyer]

Try this:

=IF(AND(L3=M3,OR(N3={750,800})),"BackOrder",IF(AND(L3<>M3,N3=500),"Future
Order, No Stock Available",IF(AND(L3<>M3,N3=900),"Stock Available",N3)))

 

[RagDyer]

Try this:

=IF(AND(L3=M3,OR(N3={750,800})),"BackOrder",IF(AND(L3<>M3,N3=500),"Future
Order, No Stock Available",IF(AND(L3<>M3,N3=900),"Stock Available",N3)))

 

[Guest]

RadDyer
This is exactly what I wanted.
=IF(AND(L31=M31,OR(N31={900,902})),"Backorder",IF(AND(L31<>M31,N31=900),"Future
Order - No Stock Available",IF(AND(L31<>M31,N31=520),"Future Order - Stock
Available",

I added the statement below to the formula but if the answer is Backorder
Must ship complete, it gives the result "Backorder" and no other formula
error.
IF(AND(L31=M31,Q31="H"),"Backorder Must Ship Complete","Shipping Within 24
Hours"))))

 

[RagDyer]

I'm not too sure exactly what you just said.

Are you sorted out OK or not?

If not, try again to state your latest question.

 

[Guest]

Hello I apolgize.


=IF(AND(L31=M31,OR(N31={900,902})),"Backorder",IF(AND(L31<>M31,N31=900),"Future
Order - No Stock Available",IF(AND(L31<>M31,N31=520),"Future Order - Stock
Available", "Shipping Within 24 Hours"

I am using the above formula. To the formula above I added
IF(AND(L31=M31,Q3="H"),"Backorder Must Ship Complete","Shipping Within 24
Hours")))) ("Shipping within 24 hours" being the value if false, and this
only appears once.)

The formula does not work so there must be something wrong with this last IF
statement but I don't know what it is. Hope this is clearer thanks

 

[RagDyer]

Try this:

=IF(AND(L31=M31,OR(N31={900,902})),"Backorder",IF(AND(L31<>M31,N31=900),"Future
Order - No Stock Available",IF(AND(L31<>M31,N31=520),"Future Order - Stock
Available",IF(AND(L31=M31,Q3="H"),"Backorder Must Ship Complete","Shipping
Within 24 Hours"))))