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.

Could you put your formula into just words?

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Marilyn" wrote in message
...
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.

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" wrote:

Could you put your formula into just words?

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Marilyn" wrote in message
...
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.

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)))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Marilyn" wrote in message
...
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" wrote:

Could you put your formula into just words?

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Marilyn" wrote in message
...
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.

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" wrote:

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)))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Marilyn" wrote in message
...
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" wrote:

Could you put your formula into just words?

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Marilyn" wrote in message
...
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.

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.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Marilyn" wrote in message
...
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" wrote:

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)))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Marilyn" wrote in message
...
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" wrote:

Could you put your formula into just words?

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may
benefit !
---------------------------------------------------------------------------
"Marilyn" wrote in message
...
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.

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")




"Marilyn" wrote:

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.