Hi!

Try this:

=SUMPRODUCT(--(A1:A3<""),--(B1:B3<""))=ROWS(A1:A3)

This would also return FALSE:

A B
1 ABC 100
2
3 GHI 10

Biff

"Tetsuya Oguma" wrote in message
...
Hi all,

I need a one simlpe function to return true if all the pairs are entered
correctly in both Column A and B and false if ANY of the pairs misses an
entry in either Column A or B. To illustrate:

(True)
A B
1 ABC 100
2 DEF 50
3 GHI 10

(False)
A B
1 ABC 100
2 DEF
3 10

Something along the line of {=SUM(A1:A3, B1:B3)}???

Thanks in advance
---
Tetsuya Oguma Singapore