Inferior statement

0 votes

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")

Feb 10, 2023 in Others by Kithuzzz
• 38,010 points
347 views

1 answer to this question.

0 votes

Try this:

=IF(ISBLANK(A1),"Date Missing",IF((B1-A1)<365,"Death<1 year","Death >= one year"))
answered Feb 10, 2023 by narikkadan
• 63,420 points

Related Questions In Others

0 votes
1 answer

SQL Server CASE .. WHEN .. IN statement

Try this... SELECT AlarmEventTransactionTableTable.TxnID, ...READ MORE

answered Jun 14, 2022 in Others by polo
• 1,480 points
342 views
0 votes
1 answer

How to generate the "create table" sql statement for an existing table in postgreSQL

Create a table for a demo: CREATE TABLE ...READ MORE

answered Jun 20, 2022 in Others by nisha
• 2,210 points
315 views
0 votes
1 answer

How to use count and group by at the same select statement

This will do what you want (list of ...READ MORE

answered Nov 7, 2022 in Others by gaurav
• 23,260 points
606 views
0 votes
0 answers

Conditional statement (truth table) formula on Excel

What is the formula for p=>q? READ MORE

Nov 27, 2022 in Others by Kithuzzz
• 38,010 points
446 views
0 votes
1 answer

IF function in combination with an Round function Excel

I'm not sure if it is a ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 63,420 points
2,427 views
0 votes
1 answer

Excel If field with rounding

Here's your formula. Assumes your cell containing ...READ MORE

answered Sep 27, 2022 in Others by narikkadan
• 63,420 points
529 views
0 votes
1 answer

IF formula to compare a date with current date and return result

You can enter the following formula in ...READ MORE

answered Sep 27, 2022 in Others by narikkadan
• 63,420 points
551 views
0 votes
1 answer

Excel Formula - if values in columns all contain X then return

You can use the AND function: = IF(AND(A3="OK";B3="OK";C3="OK");"everything ...READ MORE

answered Nov 4, 2022 in Others by narikkadan
• 63,420 points
1,128 views
0 votes
1 answer

If Statement Not Working When Including Cells That Have Formulas

Try:  =IF(VALUE(A1)>10;1;0) I hope this helps you. READ MORE

answered Oct 23, 2022 in Others by narikkadan
• 63,420 points
431 views
0 votes
1 answer

Excel vba auto log in to hdfc bank and downloading the bank statement

That page has a bunch of nested ...READ MORE

answered Jan 6, 2023 in Others by narikkadan
• 63,420 points
441 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP