Results 1 to 9 of 9

Changing the order of text based on results

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-12-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010
    Posts
    448

    Changing the order of text based on results

    Hello. I've attached a spreadsheet. I want the order of the sentence to change based on the numbers and whether they are positive or negative. Below are more details and the spreadsheet has numbers. Thanks



    "Total expense for September was 8 higher (lower) than prior year, driven by a higher (lower) claims expense and admin expense"


    This might be hard to explain: For the second part (starting from "driven by", I would like the variable that explains more of the positive or negative variance (in the example, claims) to come first.

    Here is a different example

    Total expense for September was 6 lower than prior year, driven by a lower admin expense (claims is not included because it is higher)

    Does this make sense?

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Changing Capitalization and Text Order Within a Cell
    By olives in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 06-13-2013, 11:53 AM
  2. Replies: 4
    Last Post: 11-20-2012, 06:00 PM
  3. Changing Order of Text and Numbers in a Cell
    By drpaulmhine in forum Excel General
    Replies: 6
    Last Post: 06-12-2012, 07:02 PM
  4. Replies: 4
    Last Post: 05-31-2006, 11:45 AM
  5. Changing text order
    By quinner in forum Excel General
    Replies: 2
    Last Post: 02-15-2006, 04:53 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