You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
I have a simple formula that I'd like to make work a bit better. It's just a column that says either Yes or No depending if a submission has met the deadline. The formula simply looks at the two dates and says either yes or no. The problem is, until the date is entered, it defaults to Yes. I would like either to show No, or nothing at all. Can anyone help?
=IF(K20<F20, "YES", "NO")
K20 is submission date
F20 is deadline
Try
=if (k20>0,if(k20<F20,"Yes","No"),"")
swap the formula round, should default to NO, add another IF around it to cope with blank entries
=IF(K20>F20, “NO”, “YES”)
Try
=if (k20>0,if(k20<F20,”Yes”,”No”),””)
Thanks, but unfortunately I get a name error.
=IF(OR(K20="", F20=""), "", IF(K20<F20, “YES”, “NO”))
You can still use this with the errors, then set a conditional formatting rule to set all errors to have white text, therefore appearing blank.
Thanks, but unfortunately I get a name error.
If copying and pasting, retype the quotes. ” is not the same character as "
=IF(ISERROR(K20<F20),"",IF(K20<F20, "YES", "NO"))
You can still use this with the errors, then set a conditional formatting rule to set all errors to have white text, therefore appearing blank.
Please don't do this. If you want to handle errors then Excel has got plenty of functions to support that.
As per your request! 😄
=IF(ISBLANK(K20),"No, or nothing at all",IF(K20<L20,"YES","NO"))
RM.
You can still use this with the errors, then set a conditional formatting rule to set all errors to have white text, therefore appearing blank.
There is a special place in hell for people like you.
As per your request! 😄
=IF(ISBLANK(K20),”No, or nothing at all”,IF(K20<L20,”YES”,”NO”))
RM.
Nice try! Too many arguments, but if I remove "No," then it goes back to name error.
is the date stored as text rather than date format?
There doesn't look to be anything wrong with
=IF(ISBLANK(K20),”No, or nothing at all”,IF(K20<L20,”YES”,”NO”))
I'm guessing you've missed a " when you've retyped it and the first , is not part of a text string but a delineator.
I would however strongly encourage the use of true false in place of yes no as they're useful.
Ahhh, I forgot about ISBLANK 🤦♂️ Yeah, that.
The first reply from the Purist works in my test, as Cougar says did you type it manually?
Are the dates in columns k & f typed in or are they referencing other cells?