Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
More Fun With If, And, Or?
For one you can rewrite it as
=IF(OR(AND(E13,F14),A1=9,B1=9,C1-D11),0,50) returns zero using your example, if you want something else post back -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "M.A.Tyler" <Great Lakes State wrote in message ... 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
More Fun With If, And, Or?
Hi!
It works for me, returns 0. Biff "M.A.Tyler" <Great Lakes State wrote in message ... 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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
More Fun With If, And, Or?
Thanks for your help!
"M.A.Tyler" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|