Thread: Excel help (involving IF function)

okay so i'm trying to make this spreadsheet less typing require (so to speak). Now i think excell can do this (it better be able to) but need helping knowing how to tell it i want it to do this:

If C25>D26, then put Win in E26

If D26>C26, then put Loss in E26

If C26=D26, then put Draw in E26.


Now i've figured out how to set it up to do the win/loss bit, but can't get the draw part set up in that function. Any suggestions?

nice draco, beat me to it!

i think this also works

Code:

=IF(C25>D26,"Win",IF(D26>C26,"Loss",IF(C26=D26,"Draw")))

Originally Posted by draco7891

Nested ifs are your friend. Change the field values as needed:

Code:

=IF(A1=A2;"Draw";IF(A1>A2;"Win";"Loss"))

As long as the two values are not equal, print the first condition (the second IF) the values of which are either "Win" or "Loss", depending on the equality; if both values are equal, the first IF returns a direct value of "Draw", satisfying all conditions.

Draco

Some reason it wouldn't except that one

Originally Posted by Scotzo

nice draco, beat me to it!

i think this also works

Code:

=IF(C25>D26,"Win",IF(D26>C26,"Loss",IF(C26=D26,"Draw")))

this one did though

thanks both for the help, will make updating the sheet now much easier then before.

if you mean the C25>D26 thing, that was just me typing it wrong , meant C25>D25 (was the cell i was on, why it got made the example).