| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell formula question
I am using the following formula in one of my cells: "=C1 / D2".
The problem with this formula is that the result will be "#DIV/0!" if cell D2 contains no data. Can I somehow fix my formula so it does NOT return any value if either C1 or D2 is empty? I just want to avoid situations when the outuput of my formula is "#DIV/0!" or "#Value#" because it just doesn't look pretty to me, hahah! Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EASY QUESTION: Formula to add filename to cell | Excel Programming | |||
| Bolding Specific Cell Formula Question | Excel Discussion (Misc queries) | |||
| question about cell reference in a formula | Excel Discussion (Misc queries) | |||
| Excel question? Regarding cell formula | Excel Worksheet Functions | |||
| Question: Cell formula or macro to write result of one cell to another cell | Excel Programming | |||
Threaded Mode
