Excel IF formula
 

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

one way:

K1: =COUNTA(G1:I1)=0

In article ,
"Nick Read" wrote:

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?

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

Dear Nick:

=AND(ISBLANK(G1),ISBLANK(H1),ISBLANK(I1))

G.Morales


"Nick Read" wrote:

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

And, for the 4th option:

=COUNTBLANK(G1:I1)=3


"Nick Read" wrote:

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

And a 5th option.........

=IF(AND(G1="",H1="",I1=""),"TRUE","FALSE")

Vaya con Dios,
Chuck, CABGx3


"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

... I'll like to withdraw the array-entry
from the start-up line that's forming for the drag race <g
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

In review Nick,.........all five formulas presented do work if the subject
cells are actually empty, however, if they are "blank" as a result of a ""
return from a formula, then they respond differently........some return
FALSE for this condition.

Make sure which way you want it before you decide on one.....

Vaya con Dios,
Chuck, CABGx3



"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