Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with And OR statement
Please help with the following statement. If cells 17 and 23 have a value of
3 OR cell 29 has a value of 3, then the result should be 2. IF(AND(C17=3,C23=1)(ORC29=3),2,"") |
#2
|
|||
|
|||
=IF(OR(C29=3,AND(C17=3,C23=1)),2,"")
HTH Jason Atlanta, GA -----Original Message----- Please help with the following statement. If cells 17 and 23 have a value of 3 OR cell 29 has a value of 3, then the result should be 2. IF(AND(C17=3,C23=1)(ORC29=3),2,"") . |
#3
|
|||
|
|||
Hi,
Try this =if(or(and(c17=3,c23=3),c29=3),2,"") K.S.warrier "Jason Morin" wrote: =IF(OR(C29=3,AND(C17=3,C23=1)),2,"") HTH Jason Atlanta, GA -----Original Message----- Please help with the following statement. If cells 17 and 23 have a value of 3 OR cell 29 has a value of 3, then the result should be 2. IF(AND(C17=3,C23=1)(ORC29=3),2,"") . |
#4
|
|||
|
|||
Hi, Jason,
Thanks for responding. I entered your formula but it did not work. Any other suggestions? Kathy "Jason Morin" wrote: =IF(OR(C29=3,AND(C17=3,C23=1)),2,"") HTH Jason Atlanta, GA -----Original Message----- Please help with the following statement. If cells 17 and 23 have a value of 3 OR cell 29 has a value of 3, then the result should be 2. IF(AND(C17=3,C23=1)(ORC29=3),2,"") . |
#5
|
|||
|
|||
Try =IF(OR(C29=3,AND(C17=3,C23=3)),2,"")
This matches your description, not the parameters of your original formula which said if C17=3 and C23=1 Gord Dibben Excel MVP On Mon, 29 Nov 2004 10:44:12 -0800, "soxn4n04" wrote: Hi, Jason, Thanks for responding. I entered your formula but it did not work. Any other suggestions? Kathy "Jason Morin" wrote: =IF(OR(C29=3,AND(C17=3,C23=1)),2,"") HTH Jason Atlanta, GA -----Original Message----- Please help with the following statement. If cells 17 and 23 have a value of 3 OR cell 29 has a value of 3, then the result should be 2. IF(AND(C17=3,C23=1)(ORC29=3),2,"") . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|