One try ..
Put in K1, array-entered (press CTRL+SHIFT+ENTER)
=SUM(LEN(G1:I1))=0
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Nick Read" wrote in message
...
To whom it may concern
What it is the formula required in Microsoft excel that
will return a value of true in cell K1 if the values in
cells G1, H1 and I1 are all BLANK?
Thanks Nick Read
|