I have a worksheet (Sales Order) that sends data to three other
worksheets. I have an IF statement that sends data based on a pull
down, the formula: =IF('Sales Order'!I20="Mike",'Sales Order'!B20," ")
is located on a worksheet named "Mike Milling" it pulls data from the
Sales order worksheet. Based on criteria from the Sales Order pull down
data could go to the Mike Milling sheet or to Ray Milling and Mike
Milling. Basically I want to know if I can do something like this:
=IF('Sales Order'!I20="Mike",'Sales Order'!B20," "), OR (IF('Sales
Order'!I20="Mike & Ray",'Sales Order'!B20," ")). I'm trying to get the
data to both worksheets if Mike & Ray is chosen on the Sales Order, and
to one worksheet if just "Mike" is chosen on the Sales Order.

Any suggestions on how to use 2 IF statements for the same cell?

Thanks,

Chad

Hi
Try
=IF(OR('Sales Order'!I20="Mike",'Sales Order'!I20="Mike & Ray"),'Sales
Order'!B20," ")

--
Regards

Roger Govier


wrote in message
ps.com...
I have a worksheet (Sales Order) that sends data to three other
worksheets. I have an IF statement that sends data based on a pull
down, the formula: =IF('Sales Order'!I20="Mike",'Sales Order'!B20," ")
is located on a worksheet named "Mike Milling" it pulls data from the
Sales order worksheet. Based on criteria from the Sales Order pull
down
data could go to the Mike Milling sheet or to Ray Milling and Mike
Milling. Basically I want to know if I can do something like this:
=IF('Sales Order'!I20="Mike",'Sales Order'!B20," "), OR (IF('Sales
Order'!I20="Mike & Ray",'Sales Order'!B20," ")). I'm trying to get the
data to both worksheets if Mike & Ray is chosen on the Sales Order,
and
to one worksheet if just "Mike" is chosen on the Sales Order.

Any suggestions on how to use 2 IF statements for the same cell?

Thanks,

Chad

=IF(OR([first criteria],[second criteria]),[what to do if either is
true],[what to do if both are false])

Dave
--
Brevity is the soul of wit.


" wrote:

I have a worksheet (Sales Order) that sends data to three other
worksheets. I have an IF statement that sends data based on a pull
down, the formula: =IF('Sales Order'!I20="Mike",'Sales Order'!B20," ")
is located on a worksheet named "Mike Milling" it pulls data from the
Sales order worksheet. Based on criteria from the Sales Order pull down
data could go to the Mike Milling sheet or to Ray Milling and Mike
Milling. Basically I want to know if I can do something like this:
=IF('Sales Order'!I20="Mike",'Sales Order'!B20," "), OR (IF('Sales
Order'!I20="Mike & Ray",'Sales Order'!B20," ")). I'm trying to get the
data to both worksheets if Mike & Ray is chosen on the Sales Order, and
to one worksheet if just "Mike" is chosen on the Sales Order.

Any suggestions on how to use 2 IF statements for the same cell?

Thanks,

Chad

Roger Govier wrote:
Hi
Try
=IF(OR('Sales Order'!I20="Mike",'Sales Order'!I20="Mike & Ray"),'Sales
Order'!B20," ")

--
Regards

Roger Govier


Thanks Roger, works great