Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Folks,
I am simply trying to calculate % Change in Cost b/w two periods. Now, we may have introduced a new product in the new period which would have zero cost in the prior period. Therefore, a simple % change calculation for this product will yield a #DIV/0! error. I want to be able to copy down a formula that will first evaluate for ISerror conditions by inputting a zero value and secondly evaluate for all others by just doing a % change. I am thinking of combining if(iserror(.. with nested if functions...just not sure about the syntax. Any help is greatly appreciated |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Evaluating a start and an end date | Excel Discussion (Misc queries) | |||
Function not evaluating | Excel Discussion (Misc queries) | |||
evaluating text as if it were a formula | Excel Discussion (Misc queries) | |||
evaluating text of cells | Excel Discussion (Misc queries) | |||
Evaluating a range | Excel Discussion (Misc queries) |