Hi Tyro,
I did the following syntax:
=IF(AND(AF48<0,AJ48<0),((AJ48/AF48)-1),0)...this seems to work when my
current period is zero..
however, returns DIV/0 when prior period is zero

does it need to be tweaked up a little bit more? Thanks.....

"Tyro" wrote:


=IF(AND(previous_cost<0,current_cost<0),Your_per centage_formula,Whatever_you_want_when_one_of_the_ costs_is_0)

Tyro

"Shams" wrote in message
...
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