Displaying 1 result from an estimated 1 matches for "rcjuiprofdet".
2009 Mar 15
2
Testing for Inequality à la "select case"
...is could be done in Excel much tidier in my opinion (especially the
range_aux part), element by element (cell by cell),
with a VBA function as follows:
Function MyRange(x as Double) as Double
Select Case x
Case Is <= 20000
MyRange = 0.65 * x
Case Is <= 100000
RCJuiProfDet = IIf(0.40 * x < 14000, 14000, 0.4 * x)
Case Is <= 250000
RCJuiProfDet = IIf(0.3 * x < 40000, 40000, 0.3 * x)
Case Is <= 700000
RCJuiProfDet = IIf(0.25 * x < 75000, 75000, 0.25 * x)
Case Is <= 1000000
RCJuiProfDet = IIf(0.2 * x < 175000...