J

#### JamJam

Currently, I have 5 columns of 'data'. 4 columns either have an 'X' or nothing in them and the fifth column is 'Y', 'N', or nothing. Right now, to the right of that I have 4 different columns, each of which has a different formula in it. For example, my data is in columns E,F,G,H, and I (E,F,H,I are the 'X' columns and G is the 'Y'/'N' column) and to the right of that in separate columns are these formulas:

=IF((AND(E6="X",G6="Y",F6="")),"TO DO"," ")

=IF((AND(H6="X",I6="")),"WRITE BLURB"," ")

=IF((AND(E6="X",G6="")),"CHECK PIC"," ")

=IF((AND(F6="X",H6="")),"ADD TO SNA GP"," ")

What I want to do is to find a way to combine those 4 columns of formulae into 1 column. This spreadsheet is basically a massive checklist for me andthe above formulae tell me what to do for a given row based on which cellsare "checked off", so to speak. My initial thought was to try and figure out how to nest those functions, but I couldn't quite figure out the syntax.. Any thoughts?