What's in C1 now?

You can enter this in C1:

=IF(A1=B1,0,"Whatever you want in C1 when A1<B1")

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Paul987" wrote in
message ...

Thanks guys.

Both those solutions worked well, I guess it just a matter of not
thinking too into it. One more question: how can I clear a cell based
on an event, without a macro.

For instance if A1=B1, then C1=0? Ideas?

Thanks
Paul


--
Paul987
------------------------------------------------------------------------
Paul987's Profile:
http://www.excelforum.com/member.php...o&userid=24850
View this thread: http://www.excelforum.com/showthread...hreadid=479777