Multiple IF statements within one cell

[Talamon]

All,

I am using Excel 2007 and am attempting to write multiple IF statements within a cell. This multi-cell validation would be used to validate that A=B and C=D but A&B do not equal C&D as illustrated below:

A B C D
1 1 1 1 FALSE
1 1 1 0 FALSE
1 1 0 1 FALSE
1 0 1 1 FALSE
0 1 1 1 FALSE
1 1 0 0 TRUE
0 1 1 0 FALSE
0 0 1 1 TRUE
1 0 0 1 FALSE
1 0 1 0 FALSE
0 1 0 1 FALSE
1 0 0 0 FALSE
0 1 0 0 FALSE
0 0 1 0 FALSE
0 0 0 1 FALSE
0 0 0 0 FALSE

Here's the formula that I attempted to use:

=IF(A2=B2, (IF(C2=D2), (IF(A2=C2), "Error3", "OK"), "Error2"), "Error1")

However, I receive an error message stating "The formula you typed contains an error" and it highlights the D in the equation.

I am not sure why the D was flagged as an error. If anything, I thought the "Error" portions would have been flagged...

Is it possible to do a multi-cell validation in Excel?

What was wrong with my formula?

Any help would be appreciated. Thanks for reading!

Respectfully,
Talamon

[Ron Coderre]

For Row_2...try this:

Please Login or Register  to view this content.

Is that something you can work with?

[TMS]

Row 2:

Please Login or Register  to view this content.

and copy down

Your formula does not have valid cell references.


Regards, TMS

[Talamon]

Ron Coderre, that worked out well, thanks!

Can I make it display something other than False/True?

[Talamon]

TMShucks, my apologies, I did not include the cell location in my original post. I'll make the correction now.

Thanks!

[Ron Coderre]

Yes...use a structure like this:

Please Login or Register  to view this content.

[Talamon]

All,

Thank you very much! It works just the way I wanted it to!

Respectfully,
Talamon