creating functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

trying to create a function that IF B1 is >( time value), then TRANSPOSE
(number value) B2 to B3. can anyonehelp with this function
 
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.
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup / Summary Table 8
Set non-continuous PrintArea via Function / Name 0
Excel In Excel how can I block the contenent of a cell? 0
Using a worksheet function to create an unusual cell reference pat 3
SUMIF 4
which function can get the desired result? 3
Transposing Array 4
Controlling which parameteres change in fill functions 2

Back
Top