+ Reply to Thread
Results 1 to 2 of 2

Divide a number within a cell in a specific section?

  1. #1
    Registered User
    Join Date
    10-19-2011
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    5

    Divide a number within a cell in a specific section?

    Hello,

    The title may seem a little confusing but i am struggling to find the best way to explain.

    I have this code which does vary along the sheet.

    {794}Pairs: S[{3433}1 Pair[[m]A+0],{3434}5 Pairs (525784)[[m]A+5.89]]

    I need all the values in the [[m]A+5.89]] section to be divided by 1.2, normally this would be a simple code however the cell has to have the other information. Meaning this is hard for me to find a formula that grabs just this small [[m]A+5.89]] section.
    I have tried using =IF(D45,"[m]A+.*")/1.2 but this does not work.

    Please bare in mind on some cells there are more than one [[m]A+5.89]] with different numbers with in.


    Many thinks

  2. #2
    Registered User
    Join Date
    10-19-2011
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Divide a number within a cell in a specific section?

    Hard one then?

    lol

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1