If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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 atyahoodotcom ---- "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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
... 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 atyahoodotcom ---- |
#8
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I view the actual numeric value of a formula in Excel 2002. | Excel Function Help | Worksheet Functions | 0 | January 13th, 2005 10:07 PM |
WHY | General Discussion | 9 | December 16th, 2004 12:49 AM | |
Add-in functions when starting Excel programmatically | Steve K. | Worksheet Functions | 11 | July 2nd, 2004 06:38 PM |
Coverting Lotus 123 files to use with excel | Muffin1947 | General Discussion | 6 | June 20th, 2004 10:18 AM |