Thread: Missing "Need"
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Vergel Adriano Vergel Adriano is offline
external usenet poster
  
Posts: 857
Default Missing "Need"
Because the date in AG120 is greater than the date in R4. Try

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



"AlanStotty" wrote:

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?


Reply With QuoteReply With Quote