Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
% Change Formula without #DIV/0!
(Excel 2003)
Trying to find the % change (up or down) for the following data series. That data includes zeros and effects my formula Example: Column [b] is 2006 Column [C] is 2007 Column [D] would be the formula column showing % Change if Column [C] is < Column [b] then % would be negative if [C] is = [D] then no change or zero. CELL = [A1],[B1],[c1] DATA: SalespesonA,0,5 SaespersonB,4,6 SalespersonC,6,0 SalespersonD,8,3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i change a formula to its value | Excel Worksheet Functions | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
Tex Formula Does not change. | Excel Discussion (Misc queries) | |||
want to copy formula, only change one number in formula | Excel Worksheet Functions | |||
How does Data Validation change with a formula change? | Excel Worksheet Functions |