Thread: **URGENT** - Using If Or And But functions ?????????
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
NewAccessUser NewAccessUser is offline
external usenet poster
  
Posts: 4
Default **URGENT** - Using If Or And But functions ?????????
=IF(BE8<$BJ$1,IF(BG8=".", "Yes",(OR(IF(BE8$BJ$1,IF(BG8=".","No", "PIF"))))))

This formula is not working properly
BE = Date Due
BJ = Today
BG = "." (or will contain a date)

Need to have Yes if BE<BJ and BG = "."
Need to have PIF if BE< or BJ and BG = some date
Need to have No if BEBJ and BG = "."
Reply With QuoteReply With Quote