+ Reply to Thread
Results 1 to 5 of 5

Mixed Formulas using '&' with desired result not showed

  1. 10-14-2009, 10:05 PM #1
    matthew.
    matthew. is offline
    Registered User
    Join Date
    10-14-2009
    Location
    north america
    MS-Off Ver
    Excel 2007
    Posts
    4

    Question Mixed Formulas using '&' with desired result not showed

    Cell 'Yield of 100'!O4=1/6 format_fraction

    Cell 'Yield of 100'!P4=" Pie"

    Cell 'Line Item card'!12:h12=("Portion Size: ")&(ROUND('Yield of 100'!O4,2))&(" ")&('Yield of 100'!P4)

    Cell 'Line Item card'!12:h12 displays as "Portion Size: 0.17 Pie"

    desired cell display for Cell 'Line Item card'!12:h12 is "Portion Size: 1/6 Pie"

    I'm not at all bad with excel but just cant get this to work and i have several like this i want to get fixed. spend several days getting this far.

    You can download 2003 example at http://www.2shared.com/file/8438868/...CONVERTER.html
    Reply With QuoteRegister To Reply
  2. 10-14-2009, 10:14 PM #2
    Special-K
    Special-K is offline
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Mixed Formulas using '&' with desired result not showed

    Use

    TEXT(ROUND('Yield of 100'!O4,2),"0/0")
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
    Reply With QuoteRegister To Reply
  3. 10-14-2009, 10:18 PM #3
    matthew.
    matthew. is offline
    Registered User
    Join Date
    10-14-2009
    Location
    north america
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Mixed Formulas using '&' with desired result not showed

    yes thanks that worked
    i owe you one Special-k
    Reply With QuoteRegister To Reply
  4. 10-14-2009, 10:23 PM #4
    matthew.
    matthew. is offline
    Registered User
    Join Date
    10-14-2009
    Location
    north america
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Mixed Formulas using '&' with desired result not showed

    This would work if 'Yield of 100'!O4 was always a fraction sometimes it is a whole number 1 or 2 but now displays as "Portion Size: 1/1 Pie" but i do have a few ideas i can run.
    Last edited by matthew.; 10-14-2009 at 10:31 PM. Reason: i cant spell
    Reply With QuoteRegister To Reply
  5. 10-14-2009, 10:42 PM #5
    matthew.
    matthew. is offline
    Registered User
    Join Date
    10-14-2009
    Location
    north america
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Mixed Formulas using '&' with desired result not showed

    got it to work thanks again
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1