I meant with regards, to the post saying "Well, for truncating"
it is incorrect, INT rounds down to the nearest integer, TRUNC truncates

5.5
-5.5

INT returns

5
-6

while TRUNC

returns

5
-5


my post was not in response to your post

having said that without checking your formula if you want to use AND you
use it as

=IF(AND(DATEDIF(B1,"12/31/2004","y")<21,J1=1000),0,etc

meaning that if younger than 21 and if J1 is greater or equal to 1000, then
return 0, else do this or that

--
Regards,

Peo Sjoblom

(No private emails please)


"barbarat" wrote in message
...
what does that mean, please? are you referring to the first formula, and
the
INT, or something about the second formula that I need to correct...well,
i
know it needs correcting; it doesn't work. help please thanks!
--
barbarat


"Peo Sjoblom" wrote:

It is not truncating, check with a negative value

--
Regards,

Peo Sjoblom

(No private emails please)


"
wrote
in message ...
"barbarat" wrote:
Hello again...yes, I think I understand it.

Great.

The INT is for rounding, right?

Well, for truncating. It will match $1 to $1 through $1.99.
If you want to round (match $2 to $1.50 through $2.49),
change INT(...) to ROUND(...,0). If you want to match $2
to $1.01 through $2 -- i.e, to any dollar or part thereof --
use ROUNDUP(...,0) or CEILING(...,1).