On Mar 18, 12:43*pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Throw away your *AND and replace with &
& is the operator for concatenation of strings.
--
David Biddulph

"Chris" wrote in message

...



I am using this formula:
=IF(B3=C16,C16,"")*AND(IF(C3=D16,D16,""))*AND(IF(D 3=E16,E16,""))
but am getting a value error

What I am trying to do is if
B3 = 2007 and C16 =2007 have 2007 displayed in A16. This is easy using
=IF(B3=C16,C16,"")
But I would also like to check if C3 = Q3 and D16 also equals Q3, I
would like the result to be:
2007Q3 with no spaces

In addition, in my second if statement if C3 does not equal D16, but
my 3rd If statement where D3 does equal E16
I would like the result to be:
2007Accounting with no spaces
if D3=Accounting and E16 also equals Accounting

I am just using the words Accounting, 1007 and Q3 as examples as these
variables will change.

Any genius ideas out there?- Hide quoted text -

- Show quoted text -

Perfecto!