Thread: Or Function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Or Function

=if(or(c16="c",c16="d"),b16*d16,"what goes here")
or
=if(or(c16={"c","d"}),b16*d16,"what goes here")



JimS wrote:

I'm writing a long and complicated formula, so to shorter it up and
"OR" statement would probably help, but I get confused with the
syntax. So I'll start at the beginning; how would I combine this
formula using or...

If(c16="c",b16*d16,if(c16="d",b16*d16))

Thanks


--

Dave Peterson