+ Reply to Thread
Results 1 to 9 of 9

Putting text at the end of formula results

Hybrid View

  1. #1
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191

    Re: Putting text at the end of formula results

    I don't see any rounding function in your original formula. If you changed it to =Round(.75*F2,0)&" Units Reg Insulin", it should come out with the same result.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Putting text at the end of formula results

    What darkyam suggests is preferable, IMO; the result is a number and can be used in further calculations. The units are just formatting.

    With khamilton's suggestion (which is appropriate for some circumstances), the result is text. The number will appear in full precision unless you format (or round) it:

    =text(A1, "0") & " your text"
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

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