**URGENT** - Using If Or And But functions ?????????

N

NewAccessUser

=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 BE>BJ and BG = "."
 
M

Max

Think you could try/test this:
=IF(COUNTA(BE8,BG8,BJ1)<3,"",IF(ISNUMBER(BG8),"PIF",IF(AND(BE8<BJ1,BG8="."),"Yes","No")))
 
D

Don

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,BG8="."),"No",IF(BG8<>".","PIF")))
you did not say
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index formula with IF condition 1
Want To Shrink Formula 1
letters for numbers 1
SUMPRODUCT query 10
Need help with "Function to do what auto-filter does" 3
Formula in Marksheet 6
Convert Function to Sub 6
Excel - using if statements-couldn't select Excel discussion Group 1

Top