View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
M.A.Tyler
 
Posts: n/a
Default More Fun With If, And, Or?

I beleive that I've circled this one, and am close, but just can't seem to
stumble onto the complete answer.

A B C D E F
0 0 9 7 2 3

A thru F are column headings the numbers below would represent the row. What
I would like to do is this:
=IF(OR(AND(E13,F14),OR(A1=9,B1=9,C1-D11)),0,50)

In this instance the C1-D1 calculation in the "OR" area should make the
answer true or here 0. It dosn't seem to work properly with regards to the A1
and B1 problem. Any suggestions would be helpful!