+ Reply to Thread
Results 1 to 7 of 7

IF Function : IF Formula

  1. #1
    Forum Contributor
    Join Date
    12-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    387

    IF Function : IF Formula

    Hi,

    I want to create a formula that would look into the cell "A1" and if it's first letter is in Upper case,
    then I get return value of "A1", otherwise blank.

    Example
    if cell "A1" has Name "Mumbai" then get Value in cell "B1", "Mumbai",
    if cell "A2" has Name "mumbai" then get value in cell "B2", blank or False.

    any suggestions would be highly appreciated?
    My English is very poor, so please be patient >_<"

    Thanks & Regards.
    hkbhansali

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: IF Function : IF Formula

    Try

    =IF(EXACT(PROPER(LEFT(A1)),LEFT(A1)),A1,"")

  3. #3
    Forum Contributor
    Join Date
    12-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    387

    Re: IF Function : IF Formula

    Thanks 63falcondude,
    it's work fine, but can I specify that if the first letter of text "M" (UPPER) then get return value otherwise blank?

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: IF Function : IF Formula

    Maybe...
    =IF(EXACT(UPPER(LEFT(A1)),LEFT(A1)),A1,"")
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Forum Contributor
    Join Date
    12-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    387

    Re: IF Function : IF Formula

    Thanks FDibbins,
    It's work perfectly,
    Thanks again for quick help..

  6. #6
    Forum Contributor
    Join Date
    04-06-2016
    Location
    Singapore
    MS-Off Ver
    MS Office 365 & 2010
    Posts
    698

    Re: IF Function : IF Formula

    May be

    =IF(EXACT(UPPER(LEFT("M")),LEFT(A1)),A1,"")

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: IF Function : IF Formula

    Happy to help

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula Structure Error When Combining IF Function with VLOOKUP Function
    By EverClever in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-16-2017, 03:11 PM
  2. Replies: 7
    Last Post: 10-18-2016, 02:13 PM
  3. Replies: 3
    Last Post: 09-26-2016, 02:42 PM
  4. Attempting to construction a function or formula where the formula returns the row value o
    By PivotTablePSHomage in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-13-2016, 06:37 PM
  5. Multiple Vlookup Normal Formula (not array formula) or VBA Function Required
    By BoopathiK in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-17-2015, 03:06 AM
  6. Formula Creation: Using List Function + Subtraction Function
    By HelpMe! in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-09-2013, 04:52 PM
  7. Replies: 0
    Last Post: 01-19-2013, 01:35 PM

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