How do I set up an argument which asks for multiple criteria
 

I am trying to use an argument that asks for one of three criteria (2345P,
8319T, or 7026J) in cell C108, and if it finds it, enters the amount of yet
another cell, G108 into cell K108, and if not enters 0 into cell K108.

It seems there are too many arguments for the "if" argument, and I can't
seem to get the "lookup" argument to work either.

Is there another argument I should be working with?
Thanks
--
Diver

Try:

=IF(OR(C108="8319T",C108="2345P",C108="7026J"),G10 8,0)


"bj" wrote:

try in K108
=if(or(c108="2345P",C108="8319T",C108="7026J"),G10 8,0)

"HiTekDiver" wrote:

I am trying to use an argument that asks for one of three criteria (2345P,
8319T, or 7026J) in cell C108, and if it finds it, enters the amount of yet
another cell, G108 into cell K108, and if not enters 0 into cell K108.

It seems there are too many arguments for the "if" argument, and I can't
seem to get the "lookup" argument to work either.

Is there another argument I should be working with?
Thanks
--
Diver

try in K108
=if(or(c108="2345P",C108="8319T",C108="7026J"),G10 8,0)

"HiTekDiver" wrote:

I am trying to use an argument that asks for one of three criteria (2345P,
8319T, or 7026J) in cell C108, and if it finds it, enters the amount of yet
another cell, G108 into cell K108, and if not enters 0 into cell K108.

It seems there are too many arguments for the "if" argument, and I can't
seem to get the "lookup" argument to work either.

Is there another argument I should be working with?
Thanks
--
Diver

One mo

=IF(OR(C108={"8319T","2345P","7026J"}),G108,0)



HiTekDiver wrote:

I am trying to use an argument that asks for one of three criteria (2345P,
8319T, or 7026J) in cell C108, and if it finds it, enters the amount of yet
another cell, G108 into cell K108, and if not enters 0 into cell K108.

It seems there are too many arguments for the "if" argument, and I can't
seem to get the "lookup" argument to work either.

Is there another argument I should be working with?
Thanks
--
Diver

--

Dave Peterson