| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create custom function
Hi, I use the following formula all the time: =IF(H2="Saturday", "Saturday", IF(H2="Sunday", "Sunday", IF(K20.79, "Evening", "Daytime"))), where the H column has the day of the week and the K column the time. Each time I have a new speadsheet I type this in from scratch and copy it down for as many rows as I have (generally a few thosand), not a big deal I'll grant you. I was wondering would it be 'better' to make a custom function that performs this task and if so how should one go about this. I understand the concepts around creating a custom function but it's all very new. Any help would be appreicated. Andy. -- andyiain ------------------------------------------------------------------------ andyiain's Profile: http://www.excelforum.com/member.php...fo&userid=8335 View this thread: http://www.excelforum.com/showthread...hreadid=528528 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Function VLookup | Excel Discussion (Misc queries) | |||
| How to create a function using references | Excel Worksheet Functions | |||
| Custom Function | Excel Discussion (Misc queries) | |||
| Is it possible to create your own custom format? | Excel Discussion (Misc queries) | |||
| How do I create my own custom combination charts? | Charts and Charting in Excel | |||
Threaded Mode
