Can't get an OR statement to work

[still learning]

Hi,
I’m having a brain fart !!!
I can’t get the required results in X5
If W5 has “helen” or “michelle”, I want to copy what is in C5 (a number)
If W5 is blank or has a different name, I what X5 to be blank
If C5 is blank, I want X5 to be blank.

=IF(OR(W5="michelle",+C5),IF(OR(W5="helen",+C5),""))

This returns a blank cell no mater what is in W5, even if it is blank
It also returns “FALSE” if C5 is blank or 0.00
C5 is not dependent on any cell and does not have a formula in it



mike

 

[BadgerRoad]

How about:
=IF(OR(W5="michelle",W5="helen"),C5,"")

 

[still learning]

thanks BadgerRoad
I'm always making it more involved than it has to be !!!

mike

 

[Dave Patton]

=OR(W5={"michelle","helen"})*C5 and set sheet to not show 0

or


=LET(v,OR(W5={"michelle","helen"})*C5,IF(OR(C5="",v=0),"",v))