Thread: if/or formula
View Single Post
  #2  
Old April 14th, 2010, 02:51 AM posted to microsoft.public.excel.newusers
ozgrid.com
external usenet poster
 
Posts: 328
Default if/or formula

=IF(OR(I132="N",J132="M"),K132,"")



--
Regards
Dave Hawley
www.ozgrid.com
"Barny" wrote in message
...

I would like to return the result in cell K132 based on the following-

Cell K132 will return the result N or M when/if I132 = N or J132 = M

Cells I132 and J132 will not contain N or M at the same time i.e. if
I132 = N then J132 will be blank and vice versa




--
Barny