#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.

 

[DanteAmor]

Why do you multiply 1 * O4. If you have a text in cell O4, it will return you Error: "# VALUE!?

Try:

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

 

[PTori82]

Thank you!

 

[jtakw]

Hi,

You can also do this:

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

 

[PTori82]

That works, thanks!

 

[PTori82]

I have to multiply the result by 0 so I can run it in solver. How do I get the input to read "0" if it is true?

 

[jtakw]

If you're replying to me, my formula in Post # 4 Already converts TRUE to 1, and FALSE to 0

But, are you saying you want it reversed?

Edit: meaning, do you want it to convert TRUE to 0, and FALSE to 1 ?

 

[PTori82]

Yes, even if it's true I need it to say 0

 

[jtakw]

Now the Result ( 1 and 0 ) is Reversed:

=--NOT(OR(B4={"PF/C","SG/SF","PG/SF"}))

Is that what you mean.

 

[PTori82]

If it is true or false, I need it say 0. Solver will put a "1" in the box by design once I run that. The 1 put in by solver shows me what I'm looking for. Sp for now, I need the cell to either show a 0, if true, or nothing at all. Thank you so much for your help so far!