If/and function

Closed
kath7564 - Apr 24, 2017 at 04:52 PM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Apr 26, 2017 at 12:24 PM
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

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Apr 24, 2017 at 10:20 PM
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.
0
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
0
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Apr 25, 2017 at 11:44 AM
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
0
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Apr 26, 2017 at 12:24 PM
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.
0