G
grumpy
trying to create a function that IF B1 is >( time value), then TRANSPOSE
(number value) B2 to B3. can anyonehelp with this function
(number value) B2 to B3. can anyonehelp with this function
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mallycat
can you be more descriptive. What does transpose mean?
G
grumpy
copy or move
R
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.
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.
B
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)
=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)