I'm currently producing a league table for football in excel and I
wanted to have column showing if a team has moved up, down or stayed
the same position in the table, from the previous week.

I tried to use an IF function to say e.g. IF(A2B2,"up","down) or
A2=B2,"="

Where A2 is the new league position and B2 is the previous week's
position.

What would be the correct formula to satisfy this.

I want to have "up" if the position is higher than last week and "down"
if it is lower. If it is the same i want to have "=".

Any help would be much appreciated.

Thanks

Gerard


--
gpkelly
------------------------------------------------------------------------
gpkelly's Profile: http://www.excelforum.com/member.php...o&userid=35405
View this thread: http://www.excelforum.com/showthread...hreadid=551787

Hi Gerard,

Maybe you can use something along the lines of:

=IF(A2B2,"UP",IF(A2=B2,"=","DOWN"))

Regards,
Bondi