IF function 2 Criteria

I have 2 criteria $ col & % col thresholds of 250k & 5%. I'm trying to evaluate both columns & if both criteria are met add a number starting with 1 to the column. So in Col S is $ variance Col T is % variance in colnU in putting the if formula. There is about 20 rows to evaluate & 8 of them meet this criteria. I'd like to have the formula number then 1-8 as it identifies them. Could easily do it manually but thought it was interesting. Thanks for any help you provide. Also my amounts show up in thousands as far as number formatting goes so 250K actually a shows as 250.

Originally Posted by kev_

It would be easier if you attach a workbook illustrating what you want

To attach a workbook
- click REPLY
- click GO ADVANCED
- look below for MANAGE ATTACHMENTS
- follow screen instructions
Thanks

Book attached...I think

Maybe?

=IF(AND(ABS(D4)>=250000,ABS(E4)>=0.05),MAX($F$3:F3)+1,"")

Awesome Thanks everyone!