| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if or problem
I have the data
0.102365034 9.419 #NUM! #NUM! 0 div/0 I put the formula in: =IF(OR(A1=0,ISERROR(A1)),b0,1/a1-1/2.86) for the column on the right and filled down. How come my 2nd and 3rd lines on the right column aren't 9.419 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| have some problem with database | Excel Discussion (Misc queries) | |||
| Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
| Problem With Reference Update | Excel Worksheet Functions | |||
| Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
| Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Threaded Mode
