Will this do ...?

=IF(AND(A1<"",B1<""),A1 & " - " & B1,"")

Somewhat confused by "if the score is blank (i.e. the match is in the
future), then the new cell displays the date of the match".


HTH

"ChrisL" wrote:


I have what I hope will be a nice easy question for you guys... :)

I'm putting together a worksheet for our local sports league. I want to
append the scores from two cells together with a - in between them (e.g.
2-1), which works fine unless the 2nd score is a zero, in which case it
ignores the - (e.g. 20). How can I get it to display the - all the
time?

I can't change the formatting of the cells, because if the score is
blank (i.e. the match is in the future), then the new cell displays the
date of the match.

I hope that makes sense... :) ,
Chris L


--
ChrisL
------------------------------------------------------------------------
ChrisL's Profile: http://www.excelforum.com/member.php...o&userid=37767
View this thread: http://www.excelforum.com/showthread...hreadid=573439