try
=IF(OR(D5=14,SUMPRODUCT((VALUE(C5)={1,2,3})*1)),D4 ,0)

--
Don Guillett
SalesAid Software

"Ashley" wrote in message
...
Dave, That's what I just checked. They were a download from a financial
system, and so they weren't. Now, a probably dumb question. Is there a
quick way to make the change other than retyping the numbers all the way
down? I've got about 26 worksheets to perform this calculation on. I
tried
highlighted and doing a number format, but that didn't work.

Thanks again!

"Dave F" wrote:

I just tested it out on my machine and it works if O1 = 14.

Are your values in column O formatted as numbers?

Dave
--
Brevity is the soul of wit.


"Ashley" wrote:

Dave, It's working for the values in J, but it's not working if there's
a 14
in column O. And ideas?

Thanks, Ashley

"Dave F" wrote:

This should do it:
=IF(OR(J1=7,J1=8,J1=52,J1=60,J1=70,J1=71,J1=80,O1= 14),N1,0)

Enter in P1 and fill down.

Dave
--
Brevity is the soul of wit.


"Ashley" wrote:

Hi! Any help is greatly appreciated.

I have a multi-row, multi-column worksheet. In column J I have a
list of
numbers. In column O I have a different set of numbers. For each
row, there
is a unique value in column J and column O.

1) For each row, in column P, I would like the numeric amount from
column N
to appear IF 1) the number in column J equals 07, 08, 52, 60, 70,
71, or 80
OR 2) if the number in column O equals 14, if neither of these are
true, then
I would like a 0 to appear.

Any ideas or suggestions? Thanks!