Results 1 to 13 of 13

Excel 2007 : Help needed to write a subtraction formula

Threaded View

  1. #1
    fxtrader
    Guest

    Help needed to write a subtraction formula

    I'm trying to write a formula that will deduct one number from another with varying decimal places to achieve a positive number result. e.g.

    1.32650 - 1.32750 = 10
    or
    1.32750 - 1.32650 = 10

    and

    75.250 - 75.150 = 10
    or
    75.150 - 75.250 = 10

    The answers shown above are what I need to achieve.

    Attached is what I have so far, however I have to adjust the formula each time depending on whether I'm subtracting three or five decimal places.

    This has plagued me for weeks, any assistance would be greatly appreciated.

    Thanks in advance, FXtrader
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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