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.