View Single Post
  #3   Report Post  
K.S.Warrier
 
Posts: n/a
Default

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,"")
.