Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
**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 = "." |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
**URGENT** - Using If Or And But functions ?????????
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 = "." |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
**URGENT** - Using If Or And But functions ?????????
try this - you did not say what if BE=BJ, but this may need only minor updates?
=IF(AND(BE8<$BJ$1,BG8="."),"Yes",IF(OR(BE8$BJ$1,B G8="."),"No",IF(BG8<".","PIF"))) you did not say "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 = "." |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula/functions for average and if functions | Excel Worksheet Functions | |||
Urgent help..nested functions.. | Excel Discussion (Misc queries) | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
A URGENT problem about the array functions =TABLE | Excel Worksheet Functions | |||
Urgent-Urgent VBA LOOP | Excel Discussion (Misc queries) |