+ Reply to Thread
Results 1 to 5 of 5

Simple math formula

  1. #1
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Excel 2007
    Posts
    605

    Simple math formula

    A1=39.7
    B1=38.6 - 68.9
    Here, Cell A1 contains single data but B1 data is together & that is separated by dash, so from here I need to solve below calculations
    Please Login or Register  to view this content.

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Simple math formula

    In C1 thru F1 enter:

    =--MID(B1,1,FIND("-",B1)-1)-RIGHT(B1,4)
    =A1-RIGHT(B1,4)
    =C1/RIGHT(B1,4)
    =D1/RIGHT(B1,4)
    Gary's Student

  3. #3
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Excel 2007
    Posts
    605

    Re: Simple math formula

    hi Jakobshavn,Excellent salvation, thanks for you time...

  4. #4
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Excel 2007
    Posts
    605

    Re: Simple math formula

    hi Jakobshavn , need little bit modified your formula. here RIGHT(B1,4) this logic is not applicable for all time as the data change all time
    C1=20.31-125.65= -105.34

  5. #5
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Excel 2007
    Posts
    605

    Re: Simple math formula

    got solution like :
    Please Login or Register  to view this content.

+ 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: 3
    Last Post: 07-10-2013, 06:06 PM
  2. Excel 2007 : Simple math problem
    By kingbob in forum Excel General
    Replies: 1
    Last Post: 09-10-2009, 03:21 PM
  3. formula that does simple math a specific number of times
    By salex in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-23-2007, 12:10 PM
  4. Skipping blank cells in simple math formula
    By jimtmcdaniels in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-17-2006, 01:40 AM
  5. Replies: 3
    Last Post: 02-16-2006, 07:00 AM

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