| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Divide by zero error
Whenever I use the below formula, I get a divide by zero error if one of the
numbers it uses is zero. Can someone tell me how to adjust the below formula to make it display zero instead of the divide by zero error? =((C13/C10)-E13)/((SQRT(E13*((1-E13)/C10)))*(SQRT(1-F10))) Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Divide by zero error | Excel Worksheet Functions | |||
| Divide by Zero Error | Excel Worksheet Functions | |||
| divide by 0 error jmp | New Users to Excel | |||
| Divide by zero error | Excel Discussion (Misc queries) | |||
| Divide by zero error | Excel Discussion (Misc queries) | |||
Threaded Mode
