Maybe

=IF(COUNTIF(AR187:BC187,"=0")=12,"True","False")

Mike

"DaveMoore" wrote:

The cells in the formula below contain formula themselves; could this
be why it is not working?
"False" is being returned whether or not the values of each of these
cells are zero.
I have not used =IF(SUM(AR187:BC187)=0,"True","False") because there
may be a compensating negative and positive in the range.

'=IF(AND(AR187,AS187,AT187,AU187,AV187,AW187,AX187 ,AY187,AZ187,BA187,BB187,BC187)=0,"True","False")

many thanks to anyone who can help.
Dave Moore