Excel - using if statements-couldn't select Excel discussion Group

N

NewAccessUser

I need to have result be "Yes" "No" or "PIF"
Cell BE2 = Due Date
Cell BJ1 = Today's Date
Cell BG2 = "." (or can contain a date when paid)

The due date can be greater than or less than Today's Date. If the date in
BE2<BJ1 and if BG2 = ".", then "Yes" or if BE2 >BJ1 and if BG2 = "." then
"No" else if BG2 = a date then PIF.
 
F

Fred

I noticed that nobody answered.

Instead of explaining what you are trying to do, your post desribes (in
brief confusing form) how you are trying to do it.
 

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

Top