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
|