Results 1 to 8 of 8

Nested if and Left and right statements

Threaded View

  1. #1
    Registered User
    Join Date
    01-05-2012
    Location
    Neverland
    MS-Off Ver
    2007
    Posts
    9

    Nested if and Left and right statements

    hi guys new to this forum,

    trying to write an excel nested if

    here is the situation i have mm/year in A1.. 1/2011

    from a1 to a4 i want to write out if A1 left "1" then make a1= 2, if its 2 then make a2 = 3

    thats for changing month then i need another iffor the year.. the value of a1 left is 4 then a2 will change to 01/2012 and a3 will 3/2012

    i was starting out with simple left but with 2 nested if's i get an error..
    =IF(LEFT(A1)="1",LEFT(A1 +1),A1,IF(LEFT(A1)="2",LEFT(A1+1),A1))

    you entered too many arguments for this function..

    any ideas..
    Last edited by NBVC; 01-13-2012 at 09:25 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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