Formula Help!

  • Thread starter Thread starter TylerH
  • Start date Start date
T

TylerH

I'm looking to do this:

If(B1=b OR C1=c)
Then(D1=200);
Else(D1=A1)

A B C D

1 b x 200
2 x c 200
3 x c 200
4 b x 200
5 x x 5
6 x c 200

(this is what i'm looking for
 
Hi TylerH!

One way:

D1
=IF(OR(B1="b",C1="c"),200,A1)
Copied down

The OR function returns TRUE or FALSE which is the requirement of the
condition argument of the IF function
The letters b and c need to be in quotation marks or Excel goes
looking for cells with those names.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top