Are you sure that this isn't what you need?

=IF($AG120 =R$4, IF($AH120 <=R$4, "", "need"),"")

Not certain what you are trying but to me this makes more sense.

TK


On Mar 5, 8:32 am, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
The formula is doing what you've asked it to do.

23/01/2007 = 01/01/2007
$AG120 =R$4
hence you get "" from the first IF() function, and you don't get as far as
the alternative path to the second IF().
--
David Biddulph

"AlanStotty" wrote in message

oups.com...

Hi,

I am using the following calculation in the field:

=IF($AG120 =R$4, "", IF($AH120 <=R$4, "", "need"))

where AG120 = 23/01/2007, R4 = 01/01/2007 and AH120 = 02/09/2007.

But it does not seem to populate with "need".

Any ideas?