Hi

I seek advice on a formula that I am trying to use in a spreadsheet.

There are 3 formulas in cells E1, E2 and E3 all work OK

I have put all the formulas into one, which is what I would like to have.

This is contained in cell B12. You will note that I have not placed the = symbol at this point as I get an error message.

I am not sure I the formula is to long or what is wrong.

Another pair of eyes may find where I have gone wrong.

Attached is the excel spreadsheet.

Click to view attachment

Hi

I opened the file and inserted the = sign to see what happened. I am using Excel 2010 and got the message "The specified formula cannot be entered because it uses more levels of nesting than are allowed in the current file format". I guess this is the problem, but perhaps the version of Excel you are using doesn't give as helpful a message.

I removed two levels of nesting, and it then behaved.

Hope this helps

Chris

Hi Chris

Many thanks for your response.

I had a feeling that there may have been to many arguments.

I had to ask the question.

Hi Lou

You are very welcome.

Chris

lou

you might try using the if(or(

the only issue i saw was what it 2 of the cells were "true" the formula would only return one

the other thing to try, and because all your values are 1 makes it difficult to understand what you are looking for is to concat the cells and not the formulas inside. same theory used to get around text limitations.

=E1&E2&E3

will put all three words in one cell. if only of those cells are true you would only get one word

Hi Bob

Thanks for that advice. The if(or( is something I had not considered.

lou

hope it works