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