+ Reply to Thread
Results 1 to 3 of 3

0 not showing up with text formula

  1. #1
    Registered User
    Join Date
    10-30-2014
    Location
    united states
    MS-Off Ver
    2010
    Posts
    11

    0 not showing up with text formula

    I have a formula:

    =TEXT(B48,"###")&" transactions ("&TEXT(D48,"+0%;-0%;0%")&" m/m)"

    This should pull in something like this:
    15 transactions (-50% m/m)

    However, if cell B48 is 0, it doesn't pull in the 0 and I'm left with something like:

    transactions (-100% m/m)

    How do I set this up so that it pulls in the 0?

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    8,040

    Re: 0 not showing up with text formula

    Try:


    =IF(B48=0,0,TEXT(B48,"###"))&" transactions ("&TEXT(D48,"+0%;-0%;0%")&" m/m)"

  3. #3
    Registered User
    Join Date
    10-30-2014
    Location
    united states
    MS-Off Ver
    2010
    Posts
    11

    Re: 0 not showing up with text formula

    Perfect! I knew it had to be something simple I just couldn't figure it out. Thanks!

+ 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] formula showing as text after macro entry
    By jprlimey in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-10-2014, 12:40 PM
  2. Vlookup formula showing as text in cell
    By Mile029 in forum Excel General
    Replies: 2
    Last Post: 09-15-2014, 10:17 AM
  3. [SOLVED] Showing a text instead of evaluating the formula using firmulaR1C1
    By Haleh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-09-2014, 06:24 AM
  4. showing formula as text string rather than result
    By censura in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-19-2007, 07:27 AM
  5. [SOLVED] stop showing changed text in formula bar on different level
    By ginger in forum Excel General
    Replies: 0
    Last Post: 08-15-2006, 10:20 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