IF Function
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 |
IF Function
Hi Gerard, Maybe you can use something along the lines of: =IF(A2B2,"UP",IF(A2=B2,"=","DOWN")) Regards, Bondi |
All times are GMT +1. The time now is 03:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com