if function

[Guest]

problem statement

i have three columns and i want to create a comparison formula that is based on these three columns.
i am working with a price list where column A contains codes, column B contains prices and column C specifies the year (i.e. 2002,2003,2004)
moreover, a code in column A can appear several times with a 2002,2003 or 2004 price (the price for each year is always the same)
i want column D to locate the items(codes) whose price has changed between the year 2003-2004
i would like that the formula ignores the 2002 cells and compares only the 2003 and 2004 cells.
how could i achieve that
your help would save me considerable time!!

 

[steve smallman]

Angie,

I've just had a play with a pivot table solution that
didn't permit me to differentiate between the prices
using a formula. It was anice summary, but didn't do what
you want.

Can you sort the data according to code? If so, you could
use nested if statements along the line of

aa 2002 1
aa 2003 1
aa 2004 1 =if(a3=a2, if(b3=2004, if
(c3=c2,"","change"),"")"")

which should test a3 and a2, and if the same, then go on
to test whether this is a 2004 entry, and if so test
whether the price has changed.

Steve

-----Original Message-----
problem statement:

i have three columns and i want to create a comparison

formula that is based on these three columns.

i am working with a price list where column A contains

codes, column B contains prices and column C specifies
the year (i.e. 2002,2003,2004).

moreover, a code in column A can appear several times

with a 2002,2003 or 2004 price (the price for each year
is always the same).

i want column D to locate the items(codes) whose price

has changed between the year 2003-2004.

i would like that the formula ignores the 2002 cells and

compares only the 2003 and 2004 cells.