| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF formula with certain conditions to achieve a desired value
Hi,
Am Wed, 12 Feb 2014 02:39:37 +0000 schrieb Excel Dumbo: 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 in C2 try: ="Q"&ROUNDUP(INT(A2)/3,0) &" "&10000*MOD(A2,1) and copy down Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
|
#3
|
|||
|
|||
|
thank you very much Claus. Formula worked perfect
|
| Reply |
| 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 | |||
Hybrid Mode
