| 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 |
| 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 | |||
Threaded Mode
