On Mar 5, 3:59 pm, "Cortez" wrote:
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

roups.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?- Hide quoted text -

- Show quoted text -

Try this link for example, it should open an excel file. Shows you
what I want, just need the formula so it can work it out itself.
Thanks for bearing with me.

http://spreadsheets.google.com/fm?ke...3497&f mcmd=4