| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function question
Using a collegues formula: =IF(D6=0,0,F6/D6)
I am trying to get the % change between columns D and E. Problem is D and E contain Zero at times. If D has a negative number or Zero, the % change is not always accurate. Tried the following, but if D is a zero then the result will not always be correct. =IF(D6<=0,0+F6,E6/D6-1) Especially if D1=0, E1=2. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| question about ABS Function | Excel Worksheet Functions | |||
| Function Question | Excel Discussion (Misc queries) | |||
| If Function Question?? | Excel Discussion (Misc queries) | |||
| Function Question | Excel Worksheet Functions | |||
| Function question | Excel Worksheet Functions | |||
Threaded Mode
