 |  |  |  |  |  |  |  |
If then Statement in excel using data in 2-3 columns
 |
I am trying to create an If Then statement to use in an excel spreadsheet using data from 2 or 3 columns.
Column AB has text. Column AA has a date in it. I need the statement to say if column AB says RFEP or TRFE and Column AA is greater than 08/01/07, the true value is "Y" and the false value is "N".
=IF((AA2>08/01/07)+(AB2="RFEP"),"Yes","No") This is only picking up the date in AA2. I tried the & for a connector and got “value” only.
As you can see, I haven't even tried to add the TRFE information.
I would also like to add column X to the mix. If column X has a "Y" in it, it would also be included in the true value of "Y". However, I would be very happy with just the first two items.
Thank you for the help.
Column AB has text. Column AA has a date in it. I need the statement to say if column AB says RFEP or TRFE and Column AA is greater than 08/01/07, the true value is "Y" and the false value is "N".
=IF((AA2>08/01/07)+(AB2="RFEP"),"Yes","No") This is only picking up the date in AA2. I tried the & for a connector and got “value” only.
As you can see, I haven't even tried to add the TRFE information.
I would also like to add column X to the mix. If column X has a "Y" in it, it would also be included in the true value of "Y". However, I would be very happy with just the first two items.
Thank you for the help.
|
Similar Threads
- Converting Excel Data to MSAccess .MDB in VB.NET (VB.NET)
- Reading excel data using vb 6.0 (Visual Basic 4 / 5 / 6)
- Using Excel Data for Combo Box (Visual Basic 4 / 5 / 6)
- Formatting Excel Data (Python)
- how to import excel data into mySql (PHP)
- Get data out of excel file stored as an image (MS SQL)
- Extract MS Excel Data embedded in MS Word (Visual Basic 4 / 5 / 6)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Reading from a database
- Next Thread: Error checking for an existing record
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
