I am trying to simplify this code in Excel because I revive 64 level of nesting. In this formula I want to find numbers between upper and lower limits. If the number in D1 was in range then IF function must return a specific number. Formula is:
=IF(AND(D1>=0,D1<=100,D5=50000000),1017500,IF(AND(D1>=0,D1<=100,D5=100000000),1086300,IF(AND(D1>=0,D1<=100,D5=150000000),1155000,IF(AND(D1>=0,D1<=100,D5=200000000),1223800,IF(AND(D1>=101,D1<=500,D5=50000000),1489600,IF(AND(D1>=101,D1<=500,D5=100000000),1590300,IF(AND(D1>=101,D1<=500,D5=150000000),1690900,IF(AND(D1>=101,D1<=500,D5=200000000),1791600 . . .
Anyone has a clue?
Aucun commentaire:
Enregistrer un commentaire