C1 is a number that is manually entered on another sheet and is changed on a
daily bases. Correction to previous. this formula would be located in say D1.
I want D1 to up date to reflect the value of C1 only when the dates in A1=B1.
If A1 is not + B1 I want d1 to reflect the last value of c1.

"iturnrocks" wrote:


jts Wrote:
Hi maybe you guys can helpme. I have an if function that is comparing
to
dates say in A1 and B1 (A1=B1). if true it returns the value in cell
C1
(240). If false I want it to do nothing. That is the part I am have
problems
with. Leaving False blank causes cell C1 value to change. I want cell
C1 to
remain the number it is untill the dates in A1=B1. Any help would be
appreciated.

Where does the C1 value come from originally?


--
iturnrocks
------------------------------------------------------------------------
iturnrocks's Profile: http://www.excelforum.com/member.php...o&userid=37246
View this thread: http://www.excelforum.com/showthread...hreadid=569861