Think you could try/test this:
=IF(COUNTA(BE8,BG8,BJ1)<3,"",IF(ISNUMBER(BG8),"PIF ",IF(AND(BE8<BJ1,BG8="."),"Yes","No")))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"NewAccessUser" wrote:
=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 = "."