Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Checking that any cells are null
I've got thirty five cells in a row (sequential columns) with the answer
shown in the next colun. I want the answer to show only when all previous cells are filled with a value. The narrative of the formula in col F would be along the lines of : if ((A1 or B1 or C1 or D1 or E1.....etc = "") then "", otherwise calculate the answer Can SKS tell me what the excel formuale might be. Tx Robin |
#2
|
|||
|
|||
=IF(COUNTA(A1:AI1)=35,"ok","not ok")
-- HTH Bob Phillips "RFJ" wrote in message ... I've got thirty five cells in a row (sequential columns) with the answer shown in the next colun. I want the answer to show only when all previous cells are filled with a value. The narrative of the formula in col F would be along the lines of : if ((A1 or B1 or C1 or D1 or E1.....etc = "") then "", otherwise calculate the answer Can SKS tell me what the excel formuale might be. Tx Robin |
#3
|
|||
|
|||
Try
=IF(OR(A7="",B7="",C7="",D7=""),"","HI") or =IF(OR(ISBLANK(A7),ISBLANK(B7)),"","Hi") "RFJ" wrote: I've got thirty five cells in a row (sequential columns) with the answer shown in the next colun. I want the answer to show only when all previous cells are filled with a value. The narrative of the formula in col F would be along the lines of : if ((A1 or B1 or C1 or D1 or E1.....etc = "") then "", otherwise calculate the answer Can SKS tell me what the excel formuale might be. Tx Robin |
#4
|
|||
|
|||
I would recommend
=if(countblanks(A1:BJ1)0,"",your equation) I like count blanks because CountA and Isblank both classify "" as filled. "RFJ" wrote: I've got thirty five cells in a row (sequential columns) with the answer shown in the next colun. I want the answer to show only when all previous cells are filled with a value. The narrative of the formula in col F would be along the lines of : if ((A1 or B1 or C1 or D1 or E1.....etc = "") then "", otherwise calculate the answer Can SKS tell me what the excel formuale might be. Tx Robin |
#5
|
|||
|
|||
bj wrote...
I would recommend =if(countblanks(A1:BJ1)0,"",your equation) I like count blanks because CountA and Isblank both classify "" as filled. .... But that begs the question whether the OP wants to treat cells evaluating to "" the same as truly blank cells. On the grounds that cells evaluating to "" *APPEAR* blank, what about cells evaluating to sequences of CHAR(32) and/or CHAR(160) and nothing else? They'd also *APPEAR* blank. |
#6
|
|||
|
|||
to the best of my knowledge, I have not had a cell end up with Char(32) or
Char(160) thanks for bringing this up. "Harlan Grove" wrote: bj wrote... I would recommend =if(countblanks(A1:BJ1)0,"",your equation) I like count blanks because CountA and Isblank both classify "" as filled. .... But that begs the question whether the OP wants to treat cells evaluating to "" the same as truly blank cells. On the grounds that cells evaluating to "" *APPEAR* blank, what about cells evaluating to sequences of CHAR(32) and/or CHAR(160) and nothing else? They'd also *APPEAR* blank. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checking for empty cells in a range | Excel Worksheet Functions | |||
REVISED ?? - populate limited cells w/ set value | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Skipping Blank Or Null Cells In a Lookup Function | Excel Worksheet Functions | |||
Trouble with Averaging across several worksheets | Excel Worksheet Functions |