Does Excel have Threshold function?
 

Hi,

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

Thanks,
Jo

Does Excel have Threshold function?
 

Jo,

What do you want to do?

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

HTH,
Bernie
MS Excel MVP


"Jo" wrote in message
ps.com...
Hi,

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

Thanks,
Jo

Does Excel have Threshold function?
 

On Aug 21, 2:29 pm, "Bernie Deitrick" <deitbe @ consumer dot org
wrote:
Jo,

What do you want to do?

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

HTH,
Bernie
MS Excel MVP

"Jo" wrote in message

ps.com...



Hi,

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

Thanks,
Jo- Hide quoted text -

- 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

Does Excel have Threshold function?
 

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

and in A1
=RANDBETWEEN(1,10)

Mike


"Jo" wrote:

On Aug 21, 2:29 pm, "Bernie Deitrick" <deitbe @ consumer dot org
wrote:
Jo,

What do you want to do?

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

HTH,
Bernie
MS Excel MVP

"Jo" wrote in message

ps.com...



Hi,

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

Thanks,
Jo- Hide quoted text -

- 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

Does Excel have Threshold function?
 

On Aug 21, 3:10 pm, Mike H wrote:
Try
=IF(A1<5,A1,0)

and in A1
=RANDBETWEEN(1,10)

Mike



"Jo" wrote:
On Aug 21, 2:29 pm, "Bernie Deitrick" <deitbe @ consumer dot org
wrote:
Jo,

What do you want to do?

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

HTH,
Bernie
MS Excel MVP

"Jo" wrote in message

ups.com...

Hi,

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

Thanks,
Jo- Hide quoted text -

- 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- Hide quoted text -

- Show quoted text -

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

Jo

Does Excel have Threshold function?
 

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(A33,A3,0)

HTH,
Bernie
MS Excel MVP

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

How please?

Jo

Does Excel have Threshold function?
 

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

If you are interested in the numbers 1-10, and wanted n3. 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%)

--
Dana DeLouis



"Jo" wrote in message
ps.com...
On Aug 21, 3:10 pm, Mike H wrote:
Try
=IF(A1<5,A1,0)

and in A1
=RANDBETWEEN(1,10)

Mike



"Jo" wrote:
On Aug 21, 2:29 pm, "Bernie Deitrick" <deitbe @ consumer dot org
wrote:
Jo,

What do you want to do?

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

HTH,
Bernie
MS Excel MVP

"Jo" wrote in message

ups.com...

Hi,

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

Thanks,
Jo- Hide quoted text -

- 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- Hide quoted text -

- Show quoted text -

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

Jo