Thread
:
Multiple if/then, OR formulas
View Single Post
#
10
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Multiple if/then, OR formulas
another idea
=IF(SUMPRODUCT((j5={1,2,3})*1),n5,0)
to also use the OR
=IF(OR(o5=14,SUMPRODUCT((j5={1,2,3})*1)),N4,0)
--
Don Guillett
SalesAid Software
"Ashley" wrote in message
...
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!
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett