Hello, I have the formula below with date fields. How can I please include an error message in my formula if AP2 is blank?
=IF(P2-AP2<365,"Death<1 year",Death >=one year")
I have tried adding iferror and'"Date missing")
=IF(ISBLANK(A1),"Date Missing",IF((B1-A1)<365,"Death<1 year","Death >= one year"))
Create a table for a demo:
CREATE TABLE ...READ MORE
This will do what you want (list of ...READ MORE
What is the formula for p=>q?
I'm not sure if it is a ...READ MORE
Here's your formula. Assumes your cell containing ...READ MORE
You can enter the following formula in ...READ MORE
You can use the AND function:
= IF(AND(A3="OK";B3="OK";C3="OK");"everything ...READ MORE
I hope this helps you.
That page has a bunch of nested ...READ MORE
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.