+ Reply to Thread
Results 1 to 2 of 2

How to generate a letter as an output instead of a number?

Hybrid View

  1. #1
    Registered User
    Join Date
    03-12-2017
    Location
    New Zealand
    MS-Off Ver
    2013
    Posts
    25

    How to generate a letter as an output instead of a number?

    Hi

    If A2 is greater than B2 then I want cell A1 to display the letter H
    If B2 is greater than A2 then I want cell A1 to display the letter S

    I tried to use the following:
    =IF(A2>B2,H,S)

    However the letters in that formula do not mean anything to excel at this point.

    What is the solution?

    Thanks.

  2. #2
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: How to generate a letter as an output instead of a number?

    Hi limpfisch, just enclose literal text in quotes:
    =IF(A2>B2,"H","S")
    Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
    Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee

+ 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. [SOLVED] Generate random Code consist of number and letter using VBA code
    By mazan2010 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 06-27-2017, 11:03 AM
  2. Replies: 12
    Last Post: 07-19-2016, 11:25 AM
  3. Need formula that will generate Cell number and Letter
    By Jetpilot69 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-14-2014, 04:04 AM
  4. Using Excel to generate a letter...
    By jonjorowlands in forum Excel General
    Replies: 2
    Last Post: 04-16-2013, 08:30 AM
  5. how to output column letter (not number) with a formula
    By luv2glyd in forum Excel General
    Replies: 3
    Last Post: 12-23-2009, 08:43 PM
  6. Replies: 17
    Last Post: 07-16-2009, 03:12 AM
  7. [SOLVED] Format:change headers from letter to number/number to letter
    By Biff in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM

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