creating functions
 

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

creating functions
 

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

creating functions
 

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

creating functions
 

Hi

Try entering in B3
=IF(B1TIME(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" wrote in message
...
trying to create a function that IF B1 is ( time value), then
TRANSPOSE
(number value) B2 to B3. can anyonehelp with this function

creating functions
 

In B3

=IF(B1TIME(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" wrote in message
...
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