+ Reply to Thread
Results 1 to 5 of 5

Adding to cells greater than 0

  1. 03-25-2017, 06:14 PM #1
    b00
    b00 is offline
    Registered User
    Join Date
    02-09-2014
    Location
    Birmingham, England
    MS-Off Ver
    excel mac 2011
    Posts
    16

    Adding to cells greater than 0

    Hi Quick one I cant seem to get right..

    I have two columns. A and B

    In column A I have a range of values including 0 values. I want column B to show 0.15 only if there is a value greater than 0 in column A.
    If the value in column A is 0 the value in column B should also be 0

    Looking forward to the solution, I am sure I know somewhere in the back of my brain...

    Reply With QuoteRegister To Reply
  2. 03-25-2017, 06:27 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,419

    Re: Adding to cells greater than 0

    Try
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 03-25-2017, 06:28 PM #3
    southward
    southward is offline
    Valued Forum Contributor
    Join Date
    05-08-2015
    Location
    Uvalde, TX
    MS-Off Ver
    2010
    Posts
    720

    Re: Adding to cells greater than 0

    Give this a try in cell B2:

    Please Login or Register  to view this content.
    Cheers
    Reply With QuoteRegister To Reply
  4. 03-25-2017, 06:32 PM #4
    b00
    b00 is offline
    Registered User
    Join Date
    02-09-2014
    Location
    Birmingham, England
    MS-Off Ver
    excel mac 2011
    Posts
    16

    Re: Adding to cells greater than 0

    Perfect i was so close....
    Reply With QuoteRegister To Reply
  5. 03-25-2017, 06:40 PM #5
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,419

    Re: Adding to cells greater than 0

    You're welcome. Thanks for the rep.

    @southward: I think one of us has it the wrong way round
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] find value which is greater than in a range of cells and return the greater value
    By green369 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-11-2015, 02:46 AM
  2. Working with Time (Greater Than, Subtraction, ADDing)
    By fireplug30 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-03-2013, 11:27 AM
  3. Adding values until one cell is greater than the other
    By 307Milkman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-22-2013, 06:01 PM
  4. Adding Cells, if Sum is Greater than - How much greater?
    By cmersman in forum Excel General
    Replies: 5
    Last Post: 05-04-2012, 06:39 PM
  5. adding equal/greater than into formula
    By rvnwdr in forum Excel General
    Replies: 2
    Last Post: 09-23-2005, 06:05 PM
  6. Adding 2 days to the greater of three dates
    By Maddoktor in forum Excel General
    Replies: 2
    Last Post: 04-17-2005, 10:06 AM
  7. Adding a column based on greater than a date
    By Toni G. in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-17-2005, 04:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1