"Phatbob" wrote in
message ...

I need a formula that works like this.

Cell A1 has a name
Cell B1 has a date
Cell C1 has a number

If Cell A1 has a specific name and Cell B1 is do not exceed date, Cell
D1 is populated with C1.

=(A1="Name")*(B1<=Now())*C1

For B1, it would be a date prior to 7/22/06, where 7/21/06 or 7/22/06
would populate D1, but 7/23/06 would remain blank in D1.

I don't understand what you mean.

Bruno