Doubt with 3 condition

[saraskandan@gmail.com]

Can anyone help in solving the following doubt?

I have to 3 parameters

Condition 1, condition 2 and condition 3

If Condition 1 or Condition 3 has value 1 then my result should show as
10. How can I do this using if condition.

[Dave Peterson]

I thought it was working?

saraskandan@gmail.com wrote:
>
> Can anyone help in solving the following doubt?
>
> I have to 3 parameters
>
> Condition 1, condition 2 and condition 3
>
> If Condition 1 or Condition 3 has value 1 then my result should show as
> 10. How can I do this using if condition.

--

Dave Peterson

[Roger Govier]

Hi Sara

Try
=IF(OR(A1=1,A2=1),10,"something else")
where A1 holds your condition 1, A2 holds your condition 2 and "something
else" is what you want to see returned if the conditions are not met.

Regards

Roger Govier


saraskandan@gmail.com wrote:
> Can anyone help in solving the following doubt?
>
> I have to 3 parameters
>
> Condition 1, condition 2 and condition 3
>
> If Condition 1 or Condition 3 has value 1 then my result should show as
> 10. How can I do this using if condition.
>

[G Love]

Hi Sara, it's pretty much as Roger has said, except as i understand it
you want 10 returned for conditions 1 or 3 matching the criteria of '1'
but not condition 2?!

try this in excel;

A B C D E F
1 (1) 1 1 7 12 ...

2 (2) 6 0 3 1
3 (3) 1 5 1 0

In B4 enter '=IF(OR(B1=1,B3=1),10,0)' and corner drag/fill to as far
right as you require.
this will return '0' if the criteria are not met (you can put any value
here, if you want text returned you must enclose it in brackets - e.g.
try; '=IF(OR(B1=1,B3=1),10,"FAIL")'

If you want your conditions across the top, which will allow more
entries as there's 65536 columns, try the following;

A B C D
1 (1) (2) (3)
2 1 3 1 10
3 1 0 5 10
4 0 7 1 10
5 9 1 0 0

Enter; '=IF(OR(A2=1,C2=1),10,0)' in D2 and corner drag/copy the cell
down the 'D' column as far as is required.

Hope this helps.

PGLove