use of the OR() function in combination with the IF() function

[cthompson]

Hi All,

I would have thought this was an easy thing to figure out, but I am stuck getting the OR() function to work correctly in combination with the IF() function.

In this case if cell d126 is either 310 or 319 return 1 otherwise 0. When i try it individually when cell d126 meets the criteria it works and returns 1, but when I use the OR() function it returns 0?? What am i doing wrong?

=IF((D126=310) *OR(D126=319),1,0)

 

[peterhinton]

=IF(OR((D126=310),(D126=319)),1,0)

place the OR before the 2 sets of logic,

 

[cthompson]

perfect, thanks again. Now it seems so simple.