gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 660
- Office Version
- 2019
- Platform
- Windows
Hello,
I want to delete the formula if the cell has no value.
F21:F29 is the range.
F23:F29 should have the formula removed.
thank you.
I want to delete the formula if the cell has no value.
F21:F29 is the range.
F23:F29 should have the formula removed.
thank you.
The Whole Enchilada.xlsm | |||||
---|---|---|---|---|---|
F | G | H | |||
20 | Sector | Gain | Stock % | ||
21 | Tech 3X | $ (44.72) | -1.87% | ||
22 | Finance 3x | $ 119.60 | 9.01% | ||
23 | $ - | ||||
24 | $ - | ||||
25 | $ - | ||||
26 | $ - | ||||
27 | $ - | ||||
28 | $ - | ||||
29 | $ - | ||||
Schwab |
Cell Formulas | ||
---|---|---|
Range | Formula | |
F21:F29 | F21 | =IFERROR(INDEX($B:$B,AGGREGATE(15,6,ROW($B$9:$B$15)/ISNA(MATCH($B$9:$B$15,$F$20:$F20,0)),1)),"") |
G21:G29 | G21 | =IFERROR(SUMIFS($K$9:$K$15,$B$9:$B$15,$F21),"") |
H21:H29 | H21 | =IFERROR(AVERAGEIFS($L$9:$L$15,$B$9:$B$15,$F21),"") |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
F21:F29 | Cell | does not contain a blank value | text | NO |