Excel IF formula

  • Thread starter Thread starter Nick Read
  • Start date Start date
N

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
 
And a 5th option.........

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

Vaya con Dios,
Chuck, CABGx3
 
... I'll like to withdraw the array-entry
from the start-up line that's forming for the drag race <g>
 
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
 
Back
Top