LinkBack URL
About LinkBacks
The worksheet has golf scores, and I'm supposed to use an IF statement, where excel will display 1 for the player with the lowest score, and 0 for everyone else. I appreciate any help.
The worksheet has golf scores, and I'm supposed to use an IF statement, where excel will display 1 for the player with the lowest score, and 0 for everyone else. I appreciate any help.
can you post a sample file?
Sorry, I don't have it with me. I know there's four players with total scores like: Cell B20 is 43, Cell C20 is 36, Cell D20 is41, and Cell E20 is 26. The directions said to use an IF function to determine which person had the lowest points. It needs to return a value of 1 for the lowest points (winner), and 0 to the other players.
Use this
=INDEX($B$19:$E$19,MATCH(MIN(B20:E20),$B$20:$E$20,0))
you could try something like this
in cell B21 =IF(AND(B20<=$B$20,B20<=$C$20,B20<=$D$20,B20<=$E$20),1,0)
copy across to E21
the "<=" allows for ties, and the self check is there to simplify the copy operation, you could take it out after you copy it across
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Didn't see they want IF statement.
=IF(B20=MIN($B$20:$E$20),B19,IF(MIN($B$20:$E$20)=C20,C19,IF(MIN($B$20:$E$20)=D20,D19,E19)))
still good, 3 separate ways to accomplish same goal
-Edit- and I didn't see they wanted to use the MIN function...oops
Last edited by dredwolf; 11-05-2012 at 08:46 PM.
Thanks to all who replied. I will try each suggestion. I'm new to this, but I can tell that I'm going to like excel!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks