Logical Statements with more than 2 answers..

[RPopowich]

What formula can I use to do the following:

I have 3 options of what the cell will say.
IN Stock
Reserved
or a specific date

If cell A1 says Instock, I'd like A2 to say Instock.
If cell A1 says Reserved, I'd like A2 to say Reserved.
If cell A1 does NOT say Instock or Reserved, I'd like A2 to say NY OOS.

I tried multiple IF statements, but can't figure how to return 3 possible answers instead of just 2.

Also, Is there a function in excel where I can update several PIVOT tables within the same workbook at once instead of having to update them manually on each tab?

Thanks!
Robin

 

[Von Pookie]

What formula can I use to do the following:

I have 3 options of what the cell will say.
IN Stock
Reserved
or a specific date

If cell A1 says Instock, I'd like A2 to say Instock.
If cell A1 says Reserved, I'd like A2 to say Reserved.
If cell A1 does NOT say Instock or Reserved, I'd like A2 to say NY OOS.

I tried multiple IF statements, but can't figure how to return 3 possible answers instead of just 2.

For this, try:

=IF(AND(A1<>"Instock",A1<>"Reserved"),"NY OOS",A1)

 

[BrianM]

You might try this:
=IF(A1="Instock","Instock",IF(A1="Reserved","Reserved","NY OOS"))

 

[RPopowich]

Thanks very much. Works great. Do you also know if I can updated PIVOT tables all at once within the same workbook?

 

[BrianM]

This may help; not sure.

http://www.mrexcel.com/archive/Pivot/19011b.html