Results 1 to 7 of 7

Formula needed to determine higher figure and subtract lower

Threaded View

  1. #1
    Registered User
    Join Date
    03-04-2011
    Location
    devon, england
    MS-Off Ver
    Excel 2007
    Posts
    3

    Formula needed to determine higher figure and subtract lower

    Hi.. I'm an excel newbie and so would be grateful for any help with my question;

    a b c

    100 50
    100 150

    I want to get an answer for c. I need to start with col a as that is my base fig. Sometimes the figure in b is lower than a and sometimes it's higher so I need a calculation that determines which is the higher figure a or b and then subtracts the lower figure and displays it in c.
    I do not want a negative figure. Does this make sense?

    Chris.
    Last edited by tizwas; 03-04-2011 at 06:20 AM.

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