IF Statement in Excel
Hey All...
I need and IF Statement that can put a "1" in the colum after the week sales value if it is the best selling CD that week, or if its not put a 0?
And does anyone know how i can print the album name of the best selling single that week in a table? like week one = , etc?
Cheers all
PS: HERE IS THE ROUGH TABLE
ARTIST | WEEK ONE | FAV | WEEK 2 | FAV
U2 | 200 | WANT 1 HERE IF IT IS
UB40 | 100 | ITS NOT THE FAVORITE SO A 0