Results 1 to 12 of 12

IF formula To Convert Months To Quarters

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    10-10-2012
    Location
    New York
    MS-Off Ver
    Excel 2007/2010
    Posts
    337

    IF formula To Convert Months To Quarters

    I created the following formula to convert a field with months (G:G) to what quarter of the year it falls in.

    Formula: copy to clipboard
    =IF(G2={"Jan","Feb","Mar"},1,IF(G2={"Apr","May","Jun"},2,IF(G2={"Jul","Aug","Sep"},3,4)))


    It doesn't work, how do I get it to work?



    *Edit/Correction: I should probably check to see if the formula works in all the cells I want it to first.
    Last edited by Craig K.; 05-23-2013 at 05:04 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1