| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide rows if formula result is zero
My spreadsheet layout is as follows:
A B C Apples 50 20 Oranges 0 0 Bananas 15 0 I need excel to hide the rows when the results of the formulas in both column B and C are zero. Oranges would be hidden, bananas would not. If the cell in B or C is empty, I don't want it hidden. All formulas in cells I want hidden start with =sumif. I am using Excel 2000. Thanks for the help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hide rows if nil result of formula in specific column | Excel Discussion (Misc queries) | |||
| Hide a formula result until cell has been filled | Excel Discussion (Misc queries) | |||
| Hide #VALUE! in result of array formula | Excel Worksheet Functions | |||
| Hide formula result values until all components are entered | Excel Discussion (Misc queries) | |||
| Help - Need Formula To Hide Rows | Excel Discussion (Misc queries) | |||
![John[_64_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
