| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF, and, or statements combined
I have this formula where both rows is zero, but I do not want the error
Div#/0 or #value instead I want to display a zero. I have: IF(a7=0,0,100*(a7/a8)) IF(a8=0,0,100*(a7/a8)) Now I want to combine both to use if a7 or a8 are equal to zero, then give a zero. otherwise give me the value ( which in some cases is a positive value or percent) any ideas??? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
IF, and, or statements combined
The second one will do it all...
=IF(A8=0,0,100*A7/A8) -- Rick (MVP - Excel) "lite" wrote in message ... I have this formula where both rows is zero, but I do not want the error Div#/0 or #value instead I want to display a zero. I have: IF(a7=0,0,100*(a7/a8)) IF(a8=0,0,100*(a7/a8)) Now I want to combine both to use if a7 or a8 are equal to zero, then give a zero. otherwise give me the value ( which in some cases is a positive value or percent) any ideas??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can the last two if statements be combined together? | Excel Programming | |||
| IF STATEMENTS COMBINED WITH VLOOKUPS | Excel Worksheet Functions | |||
| Use of Combined IF and AND statements | Excel Discussion (Misc queries) | |||
| Combined Statements | Excel Discussion (Misc queries) | |||
| Conditional formatting combined with multiple IF statements | Excel Worksheet Functions | |||
Linear Mode
