+ Reply to Thread
Results 1 to 2 of 2

Formula to minus preivious figure if culomn A value is the same

  1. #1
    Registered User
    Join Date
    02-02-2018
    Location
    Norwich
    MS-Off Ver
    2016
    Posts
    7

    Formula to minus preivious figure if culomn A value is the same

    Hit there,

    I have this problem which I have tried to sort but cant, Ive got 900 rows to do so manually is gonna take some time and my sanity.

    I have a route number and a fuel cost, the only way i could get SQL to export was to give me the cost of each distance from base, but when they are on the same route it should be, 100, 25(not 125), 50(not 150)

    So when the route number is the same minus the one above with the same route number, but also I dont know how to do anything that will work with the first entry i.e. The first entry should should just be as it is ?

    I have posted an example of how it is and how it should be.

    Can anyone help at all ?
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,408

    Re: Formula to minus preivious figure if culomn A value is the same

    =if(a2=a1,j2-j1,j2)
    Ben Van Johnson

+ 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. Problems showing a minus figure with an IF formula...
    By Weaselwithagun in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-31-2017, 04:31 AM
  2. [SOLVED] Array formula turning my final figure into a minus value
    By chrisandsally in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-07-2015, 12:36 PM
  3. [SOLVED] calculating formula with a minus figure
    By shrubfact in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-13-2014, 01:29 PM
  4. Preventing a minus figure being displayed when linked to other formula
    By Illustris13 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-09-2013, 06:39 PM
  5. [SOLVED] I neeed help on changing a minus figure so it does not show a minus
    By Kirstg in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-24-2012, 11:44 AM
  6. Replies: 2
    Last Post: 08-17-2012, 04:56 PM
  7. Replies: 4
    Last Post: 09-24-2007, 06:12 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