View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ashley Ashley is offline
external usenet poster
 
Posts: 71
Default Multiple if/then, OR formulas

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!