Learn how to hide error values and error indicators in a cell.
By converting error values to a number (such as 0) or a descriptive text, and after that using a conditional format to hide the value, you can conceal error values. All to make it look professional and polished.
Here are the steps for more dynamic approach.
A) Hide Error Values
1) Select the cell
2) Enter formula
=IFERROR(B2/C2,"No Qty")
3) Apply to all cells
B) Apply Conditional Format
1) Select the cell
2) Home -- Conditional Formating
3) Highlight Cells Rules -- Text that Contains...
4) Enter "Qty"
5) OK
6) Apply to all cells
Here are the steps for a static text approach.
A) Remove #DIV/0 Error (Static)
1) Select any dataset cell
2) Ctrl+G
3) Special
4) Formulas
5) Leave only "Errors" checked
6) OK
7) Enter text "No Qty"
8) Ctrl + Enter
9) Apply to all cells
#microsoft #excel #exceltips #tips #exceltricks #tricksandtips
