pls try
=MIN(MATCH(B1,{-10000;0;5;10},1)-1,IF(A1>1250000,2,4))
Regards
=MIN(MATCH(B1,{-10000;0;5;10},1)-1,IF(A1>1250000,2,4))
Regards
Function YE_YE(r As Range) As Integer
Select Case True
Case r(1) > 1250000
YE_YE = 2
Case r(2) <= 0
YE_YE = 0
Case r(2) > 0 And r(2) < 5
YE_YE = 1
Case r(2) <= 5 And r(2) < 10
YE_YE = 2
Case r(2) >= 10
YE_YE = 3
End Select
=MIN(IF(B1<=0),0,IF(AND(A1>=0,B1<5),1,IF(AND(B1>=5,A1<=10),2,IF(A1>=10,3,0)))) ,IF(A1>1250000,2,3))
Title | # Comments | Views | Activity |
---|---|---|---|
Excel VBA Save Sheets in Excel file as separate Excel Files | 5 | 25 | |
VLOOKUP to a Closed Workbook | 22 | 62 | |
TT Copy Formula | 3 | 15 | |
Dynamic Vlookup Function Formula Help | 4 | 13 |
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
11 Experts available now in Live!