2008 minus 8 minus 1 gives a result of 1999
If N83 is set to TODAY(), that will be 39644, as Excel stores dates as
number of days from the beginning of 1900 (or 1904 if that option is
chosen).

39644 is greater than 1999, so your IF test is satisfied.

If you want to compare a date in N83 with 1st Auguust 2008, try
=IF(N83DATE(2008,8,1),l5+e6-j56," not finalized")
or (less rigorously)
=IF(N83--"2008-8-1",l5+e6-j56," not finalized")
--
David Biddulph

"freebee" wrote in message
...
Hi, I tried, but cell showed i5+e6-j56. My complete formula
is=IF(N832008-8-1,l5+e6-j56," not finalized") My N83 is set to today().
thanks.

"Max" wrote:

An example, in say F6: =IF(A1="x",L5+E6-J56,"")
The IF checks that if A1 contains "x"
then the calculation: L5+E6-J56 will proceed,
otherwise just return a blank: ""
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:15,700 Files:353 Subscribers:53
xdemechanik
---
"freebee" wrote:
Hi, I'd like to know how to set a formula in "value if true". I want to
get
sum of L5+e6-J56 when the value is true

Thanks.