| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating new functions | Excel Worksheet Functions | |||
| creating a excel spread sheet using ffinancial functions | Excel Worksheet Functions | |||
| Creating & Combining Macro to Functions | Excel Worksheet Functions | |||
| I have had difficulty in creating user defined functions in Excel | Excel Worksheet Functions | |||
| Creating a functions | Excel Worksheet Functions | |||
Linear Mode
