Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Looking for a solution of dividing a negative number by zero to show a result
of a negative percentage. For Example; T32=-1.47 S32=0.00 Current formula = =IFERROR(T32/S32,0) resulting in a 100% value However I would like the result to show a negative %. Thank You |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how can i use a whole number after dividing? | Excel Discussion (Misc queries) | |||
Formulas when dividing with negative numbers | Excel Worksheet Functions | |||
Dividing by unknown to get a number | Excel Worksheet Functions | |||
2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions | |||
number format keeps dividing by 100 | New Users to Excel |