| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hide the #DIV/0!
Allen helped me with this code
=IF(A2/A1<20%,"black",IF(A2/A1<40%,"pink",IF(A2/A1<60%,"orange",...))) But if I do not have a value in cell A1 or A2 I get #DIV/0! How can I hide this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you hide/un-hide the grid lines | Excel Discussion (Misc queries) | |||
| Want to Hide columns in spreadsheet but NOT hide data in chart. | Charts and Charting in Excel | |||
| How do I hide hide #REF! in Excel | Excel Discussion (Misc queries) | |||
| Hide And Un-hide Excel Toolbars | Excel Programming | |||
| How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) | |||
Threaded Mode
