Does Excel have Threshold function?

[Jo]

Hi,

If not, how it can be constructed? Any smart way?

Thanks,
Jo

 

[Bernie Deitrick]

Jo,

What do you want to do?

=IF(A1>3,"It's greater than 3","It's 3 or less.")

HTH,
Bernie
MS Excel MVP

 

[Jo]

Jo,

What do you want to do?

=IF(A1>3,"It's greater than 3","It's 3 or less.")

HTH,
Bernie
MS Excel MVP








- Show quoted text -

No, it is like this:

=if(randbetween(a1,a2)>3,randbetween(a1,a2),0).....provided the two
randbetween are IDENTICAL!

How please?

Jo

 

[Guest]

Try
=IF(A1<5,A1,0)

and in A1
=RANDBETWEEN(1,10)

Mike

 

[Jo]

Try
=IF(A1<5,A1,0)

and in A1
=RANDBETWEEN(1,10)

Mike









- Show quoted text -

I thought of this but doesn't work in my case. Any other smart way?

Jo

 

[Bernie Deitrick]

Jo,

You cannot have that as a single cell formula.

But, you could do this. In A3, for example:
=RANDBETWEEN(A1,A2)
Then in A4:
=IF(A3>3,A3,0)

HTH,
Bernie
MS Excel MVP

 

[Dana DeLouis]

=if(randbetween(a1,a2)>3,randbetween(a1,a2),0).....

If you are interested in the numbers 1-10, and wanted n>3. Would this idea
work?
Another way to say this is that you want the numbers 4-10 70% of the time.

=RANDBETWEEN(4,10)*(RAND()<=70%)