PPRuNe Forums - View Single Post - IF Statement in Excel

25th January 2007 | 03:34

#2 (permalink)

Sue Vêtements

Joined: Jan 2007

Posts: 609

Likes: 554

From: Mostly in my own imagination

..| ...A.. | ...B.. | .C. | ...D.. | .E
--|---------------------------------------
1 | ARTIST | WEEK 1 | FAV | WEEK 2 | FAV
2 | U2.... | 200... | 1.. |....... |
3 | UB40.. | 100... | 0.. |....... |
4 | ABBA.. | 150... | 0.. |....... |

Put the following formula into C2 and drag it down to the cells below (C3:C4 in this case)

=IF(B2 = MAX(B$2:B$4),"1","0")

If you want to get clever, then set up a range to replace the B$2:B$4 part.

If you want to get really clever, you can use the xldown function to define the range, but I forget the syntax for that one.

btw, I tried it and it works

Reply

0