If/and function

[Closed]
Report
-
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
-
i need to update a spreadsheet on the progress of documents being approved.

i want to create a function that states if the document is "approved" (column B) and the date (column G) is after 11/01/2016 then it will populate a word like "ok" or "current"
but i am terrible at writing extensive formulas.

2 replies

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
43
Helo kath7564,

I tried to work on the problem you posted and mentioned below is the formula you can use. From the information you provided I assume that 11/01/2016 means January 11, 2016. First you need to enter the dates in Column B in mm/dd/yyyy format means you should enter your date as 01/11/2016 then you can put this formula in the desired cell:

=IF(AND(B1="approved",G1>DATE(2016,1,11)),"ok","current")

Hope this helps. If you have further questions or you need changes in the formula, please do write back to me.
Hello

thank you for your response, when I type the function in (I am using 11/1/2016 as in November)

=if(and(b2="approved",G2>DATE(2016,11,01)),"ok","current")

I press enter and it does not give me a value, it still states the formula I just entered
Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
486
Hi Kath,

A formula should show either result or error message.

I can think of 2 ways to display formula instead of the above.
1. Start formula with apostrophe '.
2. Pressing Ctrl+t.

Best regards,
Trowa
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
43
Helo Kath,

I am sorry for the delayed response. Trowa is correct if the formula is entered incorrectly it may result in not displaying the results. You can do one thing - I am sharing an excel file here, please check this out and see what went wrong. Also, it would be great if you can mention the version of Microsoft Excel (viz. 2003, 2007, 2013, etc.) that you are working with.

Please feel free to get back to me if you need any further help.