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
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Apr 26, 2017 at 12:24 PM
Related:
- If/and function
- Find function on mac - Guide
- Accessor function c++ - Guide
- Spreadsheet function - Guide
- Hard disk definition and function - Guide
- Agp function - Guide
2 responses
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
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.
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
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
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Apr 25, 2017 at 11:44 AM
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
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
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
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.
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.
