Results 1 to 3 of 3

Thread: Trying to create a formula to accomplish the following

  1. #1

    Trying to create a formula to accomplish the following



    Register for a FREE account, and/
    or Log in to avoid these ads!

    If B5 - B6 = <=0, B7 = 0
    It B5 - B6 = >=1, B7 = the sum of B5 - B6

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    In B7 enter formula:

    =IF(B5-B6<=0,0,B5-B6)

    or

    =MAX(0,B5-B6)


  3. #3
    Thank you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •