Results 1 to 2 of 2

Thread: Min and Max formula's

  1. #1

    Min and Max formula's



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

    Hi all,

    I am hoping that someone here can help me as i am struggling to get a formula to do what i want, perhaps its not even possible!

    I have a spreadsheet that i am calculating days and amounts.

    I need the formula to add all the days and if the sum is less that 30 to return 0, if the sum of days is more than 30 i need it to return how many more than 30 it is.

    Hope that makes sense and that someone can help, this is driving me batty!

    Thanks in advance for any help.

    S

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Try something like:

    =MAX(0,SUM(E5:E9)-30)

    where E5:E9 is the range containing the number of days.


Posting Permissions

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