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

[Pecoflyer]

Cross post http://www.excelforum.com/excel-form...52#post3025152