Results 1 to 6 of 6

Thread: Formula required to calculate priority

  1. #1

    Formula required to calculate priority



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

    Can someone please calculate priority based on the conditions specified in the attachment?
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,464
    Articles
    0
    Excel Version
    Excel 2016
    Maybe?

    =INT(H2/10)

    copied down?


  3. #3
    This one should work =IF(H2>=40,$J$18,IF(AND(H2<40,H2>=30),$J$19,IF(AND(H2<30,H2>=20),$J$20,IF(AND(H2<20,H2>=10),$J$21,0)))) . You can also replace the absolute values (40,30,20) with cells to make it more flexible if your criteria should change.

  4. #4
    Hi Nesfin

    The outcome of that is the same as NBVC suggestion!

  5. #5
    I didn't check it as it had a question mark but yes it indeed does work in this instance and it's much shorter

  6. #6
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,338
    Articles
    0
    Excel Version
    2010 on Xubuntu

Posting Permissions

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