|
Formula Error
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. |
Formula Error
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. |
Formula Error
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. |
Formula Error
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. |
Formula Error
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. |
Formula Error
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. |
Formula Error
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. |
Formula Error
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" wrote: 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. |
Formula Error
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")))) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Marilyn" wrote in message ... 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" wrote: 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. |
| All times are GMT +1. The time now is 05:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com