#Value! error on if/or statement

[PTori82]

I'm looking for cell R4 to enter a "1" if cell B4= either "PF/C", "SG/SF" or "PG/SF". Here is the formula I used. Keep getting the #Value ! error. I need this to be a 1 or 0 so that I can run this as part of solver. Thank you!

=IF(OR(B4="PF/C",B4="SG/SF",B4="PG/SF"),1*O4)

I then changed it to IFERROR(OR(B4="PF/C",B4="SG/SF",B4="PG/SF"),1*O4) to try to get rid of it but cell R4 now just says either true of false.

 

[jtakw]

If it is true or false, I need it say 0. Sp for now, I need the cell to either show a 0, if true, or nothing at all.

So let's clarify, based on what you said, in Red, show 0, whether it's TRUE or FALSE ?

Or, in Blue, show 0 if TRUE, and Blank if FALSE ?

Please confirm which.

 

[PTori82]

0 if true and blank if false. Sorry for the confusion.

 

[jtakw]

Then use this:

=IF(OR(B4={"PF/C","SG/SF","PG/SF"}),0,"")

 

[PTori82]

That works! Thanks a bunch!

 

[jtakw]

Glad it worked for you, you're welcome.