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?