| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Zeros in text resulting in #div/0! even when using IF function
Ok, I'm nuts. I retrieve data constantly into an existing workbook.
Where the data is zero, when imported, it comes in as text, thus causing #div/0! errors. Of course, I've included an IF function that should return N/A or heck - I'd take a 'zero' at this point. Nadda. Below is the formula I'm using and I'd appreciate an adjustment to get this one right! =IF(D91=0,0,D71/D91). Function won't accept =IF(D91=" ",0,D71/D91). Suggestion? Thx. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text Function with Different Formatting for Number | Excel Discussion (Misc queries) | |||
| adding zero's to a text cell | Excel Worksheet Functions | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| zero supress leading zeros when chg format from text to number | Excel Worksheet Functions | |||
| Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) | |||
Threaded Mode
