Previous Topic Next Topic

Trouble with IF/OR function in Excel

Closed
krice33 Posts 1 Registration date Tuesday August 13, 2013 Status Member Last seen August 13, 2013 - Aug 13, 2013 at 12:50 PM
 Blocked Profile - Aug 13, 2013 at 03:58 PM
Hello all! I'm hoping you can help me with a problem I'm having. For reference, I have Excel 2008.

My goal is to write an IF/OR function. The function will look at two parameters. Each parameter can be either 0 or 1.

I want to write the function so that if EITHER parameter is 1, then the "composite" parameter will also be 1 (it does not matter if both =1, only one parameter needs to =1).

If BOTH parameters are 1, then the composite parameter =1. If BOTH parameters are 0, then the composite parameter =0.

This is what I have written: IF(OR(E2=1, DD2=1), 1, 0)

For some reason, when one of the parameters =0 and one parameter =1, then Excel has the composite parameter =0, when it should be =1.

What am I doing wrong?

Thank you for any assistance.
Related:

1 reply

Answer 1 / 1
Blocked Profile
Aug 13, 2013 at 03:58 PM
Good afternoon.

I have just put your formula into production, and the following formula...

=IF(OR(E2=1,D2=1),"x",0)

...Will Indeed perform exacty how you wish.

[e2=1]+[d2=1]="x"
[e2=0]+[d2=1]="x"
[e2=1]+[d2=0]="x"
[e2=0]+[d2=0]=0

0