If you want to show just that attendance has either increased or
decreased by a + or -, use this:

(If your data is in Cells A1:A3, then
B2: =IF(A2A1,"+",IF(A2<A1,"-","No Change"))


--
gailann
------------------------------------------------------------------------
gailann's Profile: http://www.excelforum.com/member.php...o&userid=30798
View this thread: http://www.excelforum.com/showthread...hreadid=504939