IfChange Function?

  • Thread starter Thread starter TKrepitch
  • Start date Start date
T

TKrepitch

Is there anything similar to an IfChange function?

I have a file that I have to update manually every week, so I want to
make it as fast as possible. Basically, I have to update certain
interest rates and the date that it changes. If the rate has not
changed, the date cell must read "No Change."

So, I would like to have something that says, "if I type a new value
into Cell X, then enter today's date in this cell, otherwise write "No
Change." It wouldn't necessarily have to insert today's date - it
could just be a link to another cell where I enter the date initially.

Thanks in advance!

Sincerely,
Tom
 
It is hard to tell what you are looking for without an
example. Is if very possible a look up table would do the
job.
 
Back
Top