Using 2 IF statements for the same cell

[ckramer7070]

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]

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

 

[ckramer7070]

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

Thanks Roger, works great