+ Reply to Thread
Results 1 to 7 of 7

Applying formula and text results into one cell

  1. #1
    Registered User
    Join Date
    11-10-2014
    Location
    Oxford, England
    MS-Off Ver
    10
    Posts
    3

    Unhappy Applying formula and text results into one cell

    Hi I'm in need of some help. I'm not the most proficient at excel formulae but I'm sure this must be possible. I'm laying out a table to show personal sales performance as a figure in ex vat. I want cells to show when someone is on holiday too.
    so for example
    2 worksheets
    inputs on sheet1 "inputs"
    performance on sheet 2 "performance"
    cell a1 on "performance" would read as "=Sheet1!A1*0.833333333333333" so when figure of 1000 is keyed into a1 on "inputs" then cell a1 on "performance" reads as £833 this will then highlight in a different colour depending if the figure is above or below target.
    What I need to do is also be able to enter "HOL" in cell A1 on the "inputs" worksheet for it then to read as "Holiday" on the performance sheet which would then in turn highlight as blue.

    TIA

    Pete

  2. #2
    Forum Contributor
    Join Date
    08-04-2014
    Location
    Riga
    MS-Off Ver
    2010
    Posts
    579

    Re: Applying formula and text results into one cell

    Difficult to give the exact solution without an example file, but if you need to add text and a formula, the general idea is this:

    =SUM(1+2)&" and "&SUM(3+4)

    The formula will show up as 3 and 7

    Apologies, if this is not what you're looking form

  3. #3
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Applying formula and text results into one cell

    Hi, It seems you need Vlookup / Index match, can you post a small sample file ?
    Click just below left if it helps, Boo?ath?

  4. #4
    Registered User
    Join Date
    11-10-2014
    Location
    Oxford, England
    MS-Off Ver
    10
    Posts
    3

    Re: Applying formula and text results into one cell

    please see example attached
    Attached Files Attached Files

  5. #5
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Applying formula and text results into one cell

    Hi, Apply the below formula in c6 and drag it down

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    11-10-2014
    Location
    Oxford, England
    MS-Off Ver
    10
    Posts
    3

    Re: Applying formula and text results into one cell

    awesome thank you just a trick!

  7. #7
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Applying formula and text results into one cell

    Hi Thanks for the feedback,
    If your Query Solved, You can mark the thread as solved and (preferably) say thanks to those who helped by clicking the Add Reputation button.

+ 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. Replies: 0
    Last Post: 10-10-2013, 04:25 AM
  2. Replies: 3
    Last Post: 06-19-2013, 03:40 AM
  3. Replies: 1
    Last Post: 02-14-2012, 05:45 PM
  4. applying a formula and returning the results
    By Silverchewy in forum Excel General
    Replies: 1
    Last Post: 03-10-2009, 04:13 AM
  5. Applying numeric values in one cell based on text in another
    By Chi_TechWriter in forum Excel General
    Replies: 3
    Last Post: 02-03-2006, 04:15 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