creating functions

[grumpy]

trying to create a function that IF B1 is >( time value), then TRANSPOSE
(number value) B2 to B3. can anyonehelp with this function

[Mallycat]

can you be more descriptive. What does transpose mean?

[grumpy]

copy or move

"Mallycat" wrote:

>
> can you be more descriptive. What does transpose mean?
>
>
> --
> Mallycat
> ------------------------------------------------------------------------
> Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
> View this thread: http://www.excelforum.com/showthread...hreadid=561381
>
>

[Roger Govier]

Hi

Try entering in B3
=IF(B1>TIME(9,15,0),B2,"")

If the time in B1 is greater than 9:15, then B3 will have the value that
is in B2, otherwise it will remain empty.
--
Regards

Roger Govier


"grumpy" <[email protected]> wrote in message
news:[email protected]...
> trying to create a function that IF B1 is >( time value), then
> TRANSPOSE
> (number value) B2 to B3. can anyonehelp with this function

[Bob Phillips]

In B3

=IF(B1>TIME(9,30,0),B2,"")

or

=IF(B1>--"9:30:00",B2,"")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"grumpy" <[email protected]> wrote in message
news:[email protected]...
> copy or move
>
> "Mallycat" wrote:
>
> >
> > can you be more descriptive. What does transpose mean?
> >
> >
> > --
> > Mallycat
> > ------------------------------------------------------------------------
> > Mallycat's Profile:
http://www.excelforum.com/member.php...o&userid=35514
> > View this thread:
http://www.excelforum.com/showthread...hreadid=561381
> >
> >