Earlier today I was given 2 formulas for a problem I was having. I started
with a formula that worked and I wanted to add 2 conditions to it. The
formula was:

=IF(OR(€˜Source Sheet!C10={€œ€�,€�C€�, €œB€�}),Source Sheet!B10).

I wanted to add a condition that would allow if C10=€�S€� for any number that
I entered in the source sheet B10 to be entered in the destination sheet B10.
The second condition would be if €œD€� was entered in the source sheet a 2 and
only 2 would be entered in the destination sheet B10. There is no number in
the B10 of the source sheet for €œD€�, and that is the way it is supposed to
be. Here are the formulas I was given, neither worked. Please help.

=IF(OR(C10={"","C","B"}),B10,IF(ISNUMBER(B10),IF(C 10="S",B10,
IF(AND(C10="D",B10=2),2,"")),""))

=IF(OR('Source Sheet'!C10={"","C","B"}),'Source Sheet'!B10,IF(OR('Source
Sheet'!C10={"","D","S"}),2,""))

Thanks,
Malcolm