Formula computing only once

[Taylor]

I'm trying to find a formula that will give a response of "1%" if a date
entered in a different cell (T14) is earlier than August 16, 2008. The
formula I've created is:

=IF(T14<"&DATE(2008,8,16)","1%","None")

This seems to compute only once. If i put a date that should give the
value_if_true response and then change it to a date that should give the
value_if_false response, it remains true. Any ideas what could be going
wrong?

Thanks

 

[RagDyer]

Try this:

=IF(T14<DATE(2008,8,16),"1%","None")

 

[Sandy Mann]

By enclosing the comparison is quotes you are making it text and any number,
which is what a date is, or even an empty cell is smaller that text so you
only get TRUE.

Try:

=IF(AND(T14<>"",T14<DATE(2008,8,16)),"1%","None")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk