Aksaboutme
New member
- Joined
- Jul 10, 2019
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2018
class 1 25% Limit Min class 1 Min class 2 Min class 3
class 2 50% 250,000 1,350 1,575 1,800
class 3 25% 500,000 1,800 2,125 2,500
1,000,000 2,250 2,600 3,375
2,000,000 2,600 3,000 4,050
Limit 250,000 3,000,000 2,880 3,375 7,500
min ????? Amount 6,000 4,000,000 4,900 6,500 6,250
5,000,000 4,320 5,400 9,900
6,000,000 6,500 8,100 8,400
7,000,000 5,760 7,200 11,000
8,000,000 7,200 9,000 13,350
9,000,000 8,500 10,600 15,500
10,000,000 9,650 12,000 17,650
-----------------------------------------------------------------------------------------------------------------
If you cannot view please look at the attached
Essentially what I am trying to do is create a logic which would return the highest min class value(from the table). However this depends on whether class 1/2/3 are filled(top left), for example as the limit entered is 250,000, then we must look towards the first row, and since class 1,2,3 all have values in them, then i wish to return min class 3 (1800)
BUT
if it were to be
CLASS 1 50%
CLASS 2 50%
CLASS 3 0%
then i wish to return min class 2 (1575)
Please do look at the attached class 2 50% 250,000 1,350 1,575 1,800
class 3 25% 500,000 1,800 2,125 2,500
1,000,000 2,250 2,600 3,375
2,000,000 2,600 3,000 4,050
Limit 250,000 3,000,000 2,880 3,375 7,500
min ????? Amount 6,000 4,000,000 4,900 6,500 6,250
5,000,000 4,320 5,400 9,900
6,000,000 6,500 8,100 8,400
7,000,000 5,760 7,200 11,000
8,000,000 7,200 9,000 13,350
9,000,000 8,500 10,600 15,500
10,000,000 9,650 12,000 17,650
-----------------------------------------------------------------------------------------------------------------
If you cannot view please look at the attached
Essentially what I am trying to do is create a logic which would return the highest min class value(from the table). However this depends on whether class 1/2/3 are filled(top left), for example as the limit entered is 250,000, then we must look towards the first row, and since class 1,2,3 all have values in them, then i wish to return min class 3 (1800)
BUT
if it were to be
CLASS 1 50%
CLASS 2 50%
CLASS 3 0%
then i wish to return min class 2 (1575)
Thanks