Formula required to calculate priority

[salafichennai]

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

 

[NBVC]

Maybe?

=INT(H2/10)

copied down?

 

[Nesfin]

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]

Hi Nesfin

The outcome of that is the same as NBVC suggestion!

 

[Nesfin]

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:

 

[Pecoflyer]

Cross post http://www.excelforum.com/excel-for...calculate-priority.html?p=3025152#post3025152