IF Function

[Gerard Sanchez]

Can anyone help me get this to work?

=IF(AND(COUNT(C20:C53,F20:F53,I20:I53)>0,IF(ISNUMBER(H51,A54,D54,G54))),SUM(B20:B53,E20:E53,H20:H51)/2,"NOT
BALANCED !")


Thanks!

 

[T. Valko]

What are you trying to do with this:

IF(ISNUMBER(H51,A54,D54,G54))

Do you want to test *every* cell or *any* cell?

Why not just use the COUNT function:

For every cell it would be:

COUNT(H51,A54,D54,G54)=4

For any cell it would be:

COUNT(H51,A54,D54,G54)>0

 

[Gerard Sanchez]

Thanks Bill!@

What are you trying to do with this:


Do you want to test *every* cell or *any* cell?

Why not just use the COUNT function:

For every cell it would be:

COUNT(H51,A54,D54,G54)=4

For any cell it would be:

COUNT(H51,A54,D54,G54)>0

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thanks Bill!@