Results 1 to 9 of 9

Multiply formula that contains text and numbers by 10

Threaded View

  1. #1
    Registered User
    Join Date
    01-08-2016
    Location
    London
    MS-Off Ver
    2012
    Posts
    23

    Multiply formula that contains text and numbers by 10

    Hello!

    My current formula:

    ="Profit: "&ROUND((((((C6-(1/(((C3*2)+C2)/C3)))*10)*C3)*((C4/C5))))+((((C4-C5)/C4)*C2)*10),2)&" BB"

    All I want is the above formula's answer multiplied by 10. Sounds simple, right?

    When I put this in: ="Profit: "&ROUND((((((C6-(1/(((C3*2)+C2)/C3)))*10)*C3)*((C4/C5))))+((((C4-C5)/C4)*C2)*100),2)&" BB"
    ^the answer becomes x100 of what it was before, not x10?

    Apologies if the way I have worded and/or explained this is poor!

    Thank you to anyone who can help me, no doubt it is a simple fix.
    Last edited by Clanty; 02-16-2016 at 05:48 PM. Reason: Mod told me

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Problem with formula in Excel
    By Bill R in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  2. [SOLVED] Problem with formula in Excel
    By Max in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-06-2005, 04:05 PM
  3. Problem with formula in Excel
    By Bill R in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 PM
  4. [SOLVED] Problem with formula in Excel
    By Bill R in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 11:05 AM
  5. Problem with formula in Excel
    By Bill R in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  6. Problem with formula in Excel
    By Max in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 07:05 AM
  7. Problem with formula in Excel
    By Max in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-06-2005, 04:05 AM
  8. Problem with formula in Excel
    By Bill R in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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