I currently have 3 columns of data and am wanting to add a 3rd based on the
criteria in the other 3, as follows:

If col A 30 and col B 30 = 10
or
If col A 30 and col c 30 = 10
or
If col c 30 and col B 30 = 10

What is the bast way to do this?

=IF((A130)+(B130)+(C130)=2,10,"")
--
David Biddulph

"The Rook" wrote in message
...
I currently have 3 columns of data and am wanting to add a 3rd based on the
criteria in the other 3, as follows:

If col A 30 and col B 30 = 10
or
If col A 30 and col c 30 = 10
or
If col c 30 and col B 30 = 10

What is the bast way to do this?

Hi,

If exactly two conditions need to be met, you could try:
=IF((A130)+(B130)+(C130)=2,1,0)
If more than one condition needs to be met (eg all 3 might be 30), you could try:
=IF((A130)+(B130)+(C130)1,1,0)

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"The Rook" wrote in message ...
I currently have 3 columns of data and am wanting to add a 3rd based on the
criteria in the other 3, as follows:

If col A 30 and col B 30 = 10
or
If col A 30 and col c 30 = 10
or
If col c 30 and col B 30 = 10

What is the bast way to do this?

A formula

=IF(OR(AND(A230,B230),AND(A230,C230),AND(B230 ,C230)),10,"")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"The Rook" wrote in message
...
I currently have 3 columns of data and am wanting to add a 3rd based on the
criteria in the other 3, as follows:

If col A 30 and col B 30 = 10
or
If col A 30 and col c 30 = 10
or
If col c 30 and col B 30 = 10

What is the bast way to do this?

Oops, make that:

If exactly two conditions need to be met, you could try:
=IF((A130)+(B130)+(C130)=2,10,0)
If more than one condition needs to be met (eg all 3 might be 30), you could try:
=IF((A130)+(B130)+(C130)1,10,0)

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"The Rook" wrote in message ...
I currently have 3 columns of data and am wanting to add a 3rd based on the
criteria in the other 3, as follows:

If col A 30 and col B 30 = 10
or
If col A 30 and col c 30 = 10
or
If col c 30 and col B 30 = 10

What is the bast way to do this?

10*(COUNTIF(A1:C1,"30")=2)


"The Rook" wrote:

I currently have 3 columns of data and am wanting to add a 3rd based on the
criteria in the other 3, as follows:

If col A 30 and col B 30 = 10
or
If col A 30 and col c 30 = 10
or
If col c 30 and col B 30 = 10

What is the bast way to do this?