Nested logic to get 6 outputs from 3x2 matrix of inputs

**andysurtees** · 02-13-2009, 12:40 AM

Hi everyone.
I'm having a mental block with what should be some reasonably simple nested logic. Basically I've got 3 possible inputs in one field and 2 in another, and want to get 6 possible results out the other end.
The sheet attached shows what i'm putting in (columns A and B) and what i'd like to get out the other end (C). The formula i need in column C is a bunch of AND's that i somehow keep getting wrong

Thanks in advance

**JBeaucaire** · 02-13-2009, 02:11 AM

First, fix the capitalization in column A.

Then put this formula in C2 and copy down:

=A2&(IF(B2<>"",", Pay Now, kit",", Free Trial, kit"))
...or
=A2&(IF(B2="upfront",", Pay Now, kit",", Free Trial, kit"))

**DonkeyOte** · 02-13-2009, 03:17 AM

JB, why not use PROPER(A2) ?

**JBeaucaire** · 02-13-2009, 03:19 AM

Originally Posted by DonkeyOte

JB, why not use PROPER(A2) ?

In my opinion, it's one thing to use tricks like PROPER to correct incoming data, it's another thing to use it instead of just correcting your own data set one time.

**DonkeyOte** · 02-13-2009, 03:20 AM

Fair enough JB

**andysurtees** · 02-15-2009, 09:09 PM

Thanks JB.
The data we get in is actually incorrectly capitalised, which i forgot to mention, so I've stuck the PROPER in there too, and now the whole thing works great