Comparison Function

Hi Folks - I have the follwoing data:

Col A Col B Col C
45 50 Increase
60 75 Increase
65 50 Decrease
44 44 Same

Is there a function I can use in Col C to determine if a cell value
increased, decreased or stayed the same? Thanks in advance.

Michael

Hi Michael

one way
=IF(OR(ISBLANK(B1),ISBLANK(A1)),"",IF(B1=A1,"Same",IF(B1-A1>0,"Increase","Decrease")))

this only puts the words in if both A1 & B1 have data in them

Cheers
julieD



"Michael" <[email protected]> wrote in message
news:wutId.20293$B95.14346@lakeread02...
> Hi Folks - I have the follwoing data:
>
> Col A Col B Col C
> 45 50 Increase
> 60 75 Increase
> 65 50 Decrease
> 44 44 Same
>
> Is there a function I can use in Col C to determine if a cell value
> increased, decreased or stayed the same? Thanks in advance.
>
> Michael
>
>
>
>
>
>
>

Also...

=LOOKUP(A2-B2,{-9.99999999999999E+307,0,2.229E-308},{"Decrease","Same","Increase"})

Michael wrote:
> Hi Folks - I have the follwoing data:
>
> Col A Col B Col C
> 45 50 Increase
> 60 75 Increase
> 65 50 Decrease
> 44 44 Same
>
> Is there a function I can use in Col C to determine if a cell value
> increased, decreased or stayed the same? Thanks in advance.
>
> Michael
>
>
>
>
>
>
>

In addition to Julie's formula, you could use:

=CHOOSE((B1>A1)+1+(A1=B1)*2,"Decrease","Increase","Same")

However, mine does not take into consideration blanks - I
suppose you could add an IF in there.

HTH
Jason
Atlanta, GA

>-----Original Message-----
>Hi Folks - I have the follwoing data:
>
>Col A Col B Col C
>45 50 Increase
>60 75 Increase
>65 50 Decrease
>44 44 Same
>
>Is there a function I can use in Col C to determine if a
cell value
>increased, decreased or stayed the same? Thanks in
advance.
>
>Michael
>
>
>
>
>
>
>
>.
>

Julie - Thanks. I understand your example the best. Thanks to all!!

Michael



"JulieD" <[email protected]> wrote in message
news:%[email protected]...
> Hi Michael
>
> one way
>
=IF(OR(ISBLANK(B1),ISBLANK(A1)),"",IF(B1=A1,"Same",IF(B1-A1>0,"Increase","De
crease")))
>
> this only puts the words in if both A1 & B1 have data in them
>
> Cheers
> julieD
>
>
>
> "Michael" <[email protected]> wrote in message
> news:wutId.20293$B95.14346@lakeread02...
> > Hi Folks - I have the follwoing data:
> >
> > Col A Col B Col C
> > 45 50 Increase
> > 60 75 Increase
> > 65 50 Decrease
> > 44 44 Same
> >
> > Is there a function I can use in Col C to determine if a cell value
> > increased, decreased or stayed the same? Thanks in advance.
> >
> > Michael
> >
> >
> >
> >
> >
> >
> >
>
>

Hi Michael

you're welcome and thanks for the feedback.

Cheers
JulieD

"Michael" <[email protected]> wrote in message
news:yOuId.20294$B95.1409@lakeread02...
> Julie - Thanks. I understand your example the best. Thanks to all!!
>
> Michael
>
>
>
> "JulieD" <[email protected]> wrote in message
> news:%[email protected]...
>> Hi Michael
>>
>> one way
>>
> =IF(OR(ISBLANK(B1),ISBLANK(A1)),"",IF(B1=A1,"Same",IF(B1-A1>0,"Increase","De
> crease")))
>>
>> this only puts the words in if both A1 & B1 have data in them
>>
>> Cheers
>> julieD
>>
>>
>>
>> "Michael" <[email protected]> wrote in message
>> news:wutId.20293$B95.14346@lakeread02...
>> > Hi Folks - I have the follwoing data:
>> >
>> > Col A Col B Col C
>> > 45 50 Increase
>> > 60 75 Increase
>> > 65 50 Decrease
>> > 44 44 Same
>> >
>> > Is there a function I can use in Col C to determine if a cell value
>> > increased, decreased or stayed the same? Thanks in advance.
>> >
>> > Michael
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>>
>>
>
>

"Jason Morin" <[email protected]> wrote...
>In addition to Julie's formula, you could use:
>
>=CHOOSE((B1>A1)+1+(A1=B1)*2,"Decrease","Increase","Same")
>
>However, mine does not take into consideration blanks - I
>suppose you could add an IF in there.
....

Or

=IF(COUNT(A1:B1)=2,CHOOSE(2+SIGN(B1-A1),"Decrease","Same","Increase"),
"Missing")

Or if this is purely for display,

=IF(COUNT(A1:B1)=2,B1-A1,"Missing")

and give the col C the number format "Increase";"Decrease";"Same".