Originally Posted by
Sprogget
The actual expression would look like =IF((Z3=Z4),"=",0) You're telling the cell in which the formula is written to compare Z3 &Z4 and if they're equal, to place an equals sign in the cell.
The syntax is =IF ( logical_test, value_if_true, value_if_false ).
That's the way I would do it, except I would use a "" (empty string) instead of a 0 if false.
I've written a quick example spreadsheet to show what I mean:
http://dl.dropbox.com/u/85261/EqualScores.xls It has the "working area" off to the right (column H on), then the final string to display or print is assembled in column A. I did separate formulas for "equal to the score above" and "equal to the score below", so you get an = sign in both matching scores.
I always try to split problems up in to multiple cells,
spread it out over the
sheet, rather than try and do it all in one cell with one big formula. Simpler is always better, and you have literally millions of cells to play in! You can always hide whole rows and columns, or just not display or print the workings. Makes it easier to write, and to troubleshoot later when you've forgotten what you did last year ...
