Check for Multiple TRUE in a spreadsheet

Hello, I have a spread sheet with multiple tests that show either TRUE or False (e.g. 1000 calculation and for each calculation I do a "Backup" check, that if correct shows "TRUE")

Now I would like to have one cell in the spread sheet, that checks if all checks are TRUE, i.e. if the excel spreadsheet is error free. is there a formula that captures my idea:

Check IF(Cell 1, Cell 2, Cell:8-26, Cell 100)= TRUE, then TRUE otherwise FALSE


Thanks!

You can do this:

=AND(Cell1,Cell2,Cell8,Cell9,Cell10,......,Cell26,Cell100)

but you have to list the individual cells - you can't specify a range of cells. There is also a limit to the number of parameters that AND can use - 255 arguments are allowed in XL2007 and later versions (I think it was limited to 32 in XL2003, which your profile states).

Hope this helps.

Pete