Hi,

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

Thanks,
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


"Jo" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
>
> If not, how it can be constructed? Any smart way?
>
> Thanks,
> Jo
>

On Aug 21, 2:29 pm, "Bernie Deitrick" <deitbe @ consumer dot org>
wrote:
> 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" <mas...@hotmail.com> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
> > 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

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(A1>3,"It's greater than 3","It's 3 or less.")
> >
> > HTH,
> > Bernie
> > MS Excel MVP
> >
> > "Jo" <mas...@hotmail.com> wrote in message
> >
> > news:(E-Mail Removed)...
> >
> >
> >
> > > 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
>
>
>

On Aug 21, 3:10 pm, Mike H <Mi...@discussions.microsoft.com> 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(A1>3,"It's greater than 3","It's 3 or less.")
>
> > > HTH,
> > > Bernie
> > > MS Excel MVP
>
> > > "Jo" <mas...@hotmail.com> wrote in message
>
> > >news:(E-Mail Removed)...
>
> > > > 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

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

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

>> > =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%)

--
Dana DeLouis



"Jo" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Aug 21, 3:10 pm, Mike H <Mi...@discussions.microsoft.com> 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(A1>3,"It's greater than 3","It's 3 or less.")
>>
>> > > HTH,
>> > > Bernie
>> > > MS Excel MVP
>>
>> > > "Jo" <mas...@hotmail.com> wrote in message
>>
>> > >news:(E-Mail Removed)...
>>
>> > > > 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
>