| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get a formula result zero as blank cell
Dear Excel experts,
How can I make the outcome of a formula (eg. =A1*A2) result in a blank cell if either Cell A1 or Cell A2 is blank (no data typed in the cell)? If either Cell A1 or A2 is actually zero it should not result in a blank Cell. I need to define the outcome of the folrmula as blank, because I want to take the average of a range of rhese formulas. If some data have not been entered, they should be ignored in the average and not counted as 0. Hope you can give me a clue, Jan Bart |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell displays formula and not result | Excel Discussion (Misc queries) | |||
| How to stop excel from plotting a "blank" cell with formula as zer | Excel Discussion (Misc queries) | |||
| formula in cell not showing result | Excel Worksheet Functions | |||
| Formula result not showing in cell | Excel Worksheet Functions | |||
| Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Threaded Mode
