Formula required to calculate priority

salafichennai

New member
Joined
Oct 25, 2012
Messages
2
Reaction score
0
Points
0
Can someone please calculate priority based on the conditions specified in the attachment?
 

Attachments

  • SLACorporateApp.xlsx
    13.3 KB · Views: 16

Nesfin

New member
Joined
Nov 7, 2012
Messages
2
Reaction score
0
Points
0
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.
 

Kevin@Radstock

New member
Joined
Oct 5, 2012
Messages
52
Reaction score
0
Points
0
Excel Version(s)
365
Hi Nesfin

The outcome of that is the same as NBVC suggestion! :)
 

Nesfin

New member
Joined
Nov 7, 2012
Messages
2
Reaction score
0
Points
0
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 :lol:
 
Top