If/Then OR combo

[jdizzle24]

I am trying to build an If/Then formula that contains multiple logical arguments. Essentially, I want the formula to return a value of 4,3,or 1 based on which cell has an X in it. Here is the formula that I have:

=(IF(K53="X","4",""),OR,IF(G53="X","3",""),OR,IF(B53="X","1",""))

This formula returns a #Value!

Any thoughts on what I have done incorrectly?

[Crooza]

=IF(K53="X","4",IF(G53="X","3",IF(B53="X","1","")))

Try this but you don't specifiy what happens when there is an X in all three cells

OH and by the way welcome and by putting your values in apostrophies you'll get htem returned as text not values

[jdizzle24]

That did it! Thanks so much, Crooza!
=IF(K53="x","4",IF(G53="x","3",IF(B53="x","1")))

[AmirSoft]

You should try

Please Login or Register  to view this content.

When first value K53 is wrong then formula will calculate the 2nd value
When 2nd value is also wrong formula will calculate 3rd value.


Click on * left end of this message

[Crooza]

Great

Glad it worked. You should mark the thread as solved now

[AmirSoft]

You should try

Please Login or Register  to view this content.

When first value K53 is wrong then formula will calculate the 2nd value
When 2nd value is also wrong formula will calculate 3rd value.


Click on * left end of this message

[jdizzle24]

Thanks again Crooza. I did not write in what happened if all three have X's as I am creating an evaluation document that will total up various parts of the sheet. So, hopefully, if my people follow the correct process, they won't have an X in each box. Also, thanks for the tip about apostrophes. I will have to fix that as well.