| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
IF formula with certain conditions to achieve a desired value
Hello friends,
Please refer attached sample file. I have dates in column A that do not appear in the date format , eg 1.2013. 2.2013, 3.2013 etc I have like to use a formula in another column B which will give me - Q1 2013(which means quarter 1) for all dates that are 1.2013, 2.2013, 3.2013 Q2 2013 (which means quarter 2) for all dates that are 4.2013, 5.2013,6.2013 Q3 2013 (which means quarter 3) for all dates that are 7.2013, 8.2013,9.2013 Q4 2013 (which means quarter 4) for all dates that are 10.2013, 11.2013,12.2013 Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a cell formula to achieve this? | Excel Discussion (Misc queries) | |||
| Formula to return desired Result | Excel Discussion (Misc queries) | |||
| Using a formula across several columns to achieve a list of result | Excel Discussion (Misc queries) | |||
| Help! Formula that can Ref. hidden data & Populate Cells with desired text | Excel Worksheet Functions | |||
| Excel Logic needs a Doctor !! FORMULA FIX DESIRED!! | Excel Programming | |||
Threaded Mode
