IF Function

[gpkelly]

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(A2>B2,"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

[Bondi]

Hi Gerard,

Maybe you can use something along the lines of:

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

Regards,
Bondi