Excel IF formula

[Nick Read]

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

 

[JE McGimpsey]

one way:

K1: =COUNTA(G1:I1)=0

 

[Max]

One try ..
Put in K1, array-entered (press CTRL+SHIFT+ENTER)
=SUM(LEN(G1:I1))=0

 

[Mexage]

Dear Nick:

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

G.Morales

 

[Duke Carey]

And, for the 4th option:

=COUNTBLANK(G1:I1)=3

 

[CLR]

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

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

Vaya con Dios,
Chuck, CABGx3

 

[Max]

... I'll like to withdraw the array-entry
from the start-up line that's forming for the drag race <g>

 

[CLR]

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