Android Question Doing Min() and Max() at the same time?

[wimpie3]

Is there a way to simplify this code?

If percentage < 0 Then percentage=0
If percentage > 1 Then percentage=1

It's a combination of Min and Max but I'm not sure such a function exists?

 

[agraham]

Are those percentage values integers or doubles? It matters as you have a 'dead band' from 0 to 0.999999.... in your comparison. ?

 

[klaus]

Maybe this:

percentage = Min(Max(percentage, 0), 1)

 

[Mahares]

How about another variant:

Log(IIf( percentage < 0, 0, IIf(percentage > 1, 1, percentage)))

 

[agraham]

@klaus suggestion is correct only for integer values. @Mahares is the same as the original post for both integer and double values.

 

[Spavlyuk]

@klaus suggestion is correct only for integer values.

What do you mean?

Dim P As Double = 0.99
Log(Min(Max(P, 0), 1)) ' Logs 0.99

 

[klaus]

@klaus suggestion is correct only for integer values.

Sorry, but this is wrong.
Min and Max work with Doubles !
I tested it before posting.

From the help:

 

[agraham]

Perhaps I misunderstood the original requirement. I assumed that the actual requirement was for percentage to end up with a value of either 0 or 1. The original code in the first post would do that for integer values but not doubles. It would leave it unchanged for the values from 0 to 0.99999.... That is why I asked for clarification in post #2.