Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 6 of 6

Thread: Calculate Number in Brackets/Parenthesis

  1. #1
    Join Date
    28th July 2006
    Posts
    3

    Calculate Number in Brackets/Parenthesis

    Is it possible to extract a number in brackets specifically from a cell, then increase it by 15%, and return the result back into the brackets.

    For example the cell consists the following:
    Mary (78)

    so the aim is to get the 78 out for calculation, then change the content of the cell with the new result.

    Or is there a macros that can be created for this?

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,708

    Re: Editing a specific value in a cell

    One way

    =--SUBSTITUTE(MID(A1,FIND("(",A1)+1,256),")","")+(SUBSTITUTE(MID(A1,FIND("(",A1)+1,256),")","")*15%)

    Or use Edit Replace and replace the ( and ) with nothing. Then copy any cell housing .15 then select the resulting numbers (after Edit>Replace) and go to Edit>Paste Special - Value - Multiply - OK

  3. #3
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,708

    Re: Editing a specific value in a cell

    BTW, if the numbers is placed back into brackets it will again become text. So use a Custom Number Format like "("0.00")"

  4. #4
    Join Date
    28th July 2006
    Posts
    3

    Re: Editing a specific value in a cell

    Thx real much.
    Just additionally asking.

    Is it possible to change a cell from Mary (78) to Mary (89.7)?
    Doing the same operation, but at the end keeping the text format?

    i'm a total excel idiot...
    Last edited by eowplum; July 28th, 2006 at 15:23.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,708

  6. #6
    Join Date
    28th July 2006
    Posts
    3

    Re: Calculate Number in Brackets/Parenthesis

    Thx real much, I understand everything now!

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 5
    Last Post: December 1st, 2012, 00:39
  2. Remove Text With Brackets & The Parenthesis
    By joop in forum EXCEL HELP
    Replies: 6
    Last Post: February 1st, 2011, 06:36
  3. Remove Parenthesis (Brackets) From Numbers
    By twin9000 in forum EXCEL HELP
    Replies: 10
    Last Post: February 3rd, 2009, 10:02
  4. Replies: 7
    Last Post: April 24th, 2008, 07:49
  5. Extract Data in Brackets/Parenthesis
    By Belinea in forum EXCEL HELP
    Replies: 10
    Last Post: June 10th, 2007, 20:36

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
  •  
porno