IF OR

[TexasCPA]

=IF(OR(L2=1,L2=2),"C", "P")

The above formula is in M2

When I hit the enter button, L2= P even though I have not enter a value in M2

When I enter a 1 in L2 the value in M2 = C and when I enter a value of 2 in L2 the value of C remains in M2

What is wrong with the formula?

Thanks for your help

 

[Fluff]

This is basically the same question you asked here IF OR FUNCTION
You need to use the same method as I showed in that thread.

 

[TexasCPA]

This is basically the same question you asked here IF OR FUNCTION
You need to use the same method as I showed in that thread.

OK sorry for the duplication. That formula came from examples when doing a search for IF OR statement

 

[Fluff]

Have you tried solving this post using the layout from you previous threads?

 

[TexasCPA]

Have you tried solving this post using the layout from you previous threads?

No Not yet- Just now read your reply from earlier today.