| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function Creation
If A1 0 AND SUM(B1:L1) = 0 then A13 = Jan
If B1 0 AND SUM(C1:L1) = 0 then A13 = Feb If D1 0 AND SUM(E1:L1) = 0 then A13 = March etc.etc. Rather than just using nested Ifs which is cumbersome I am trying: Function Month(Integer) Select Case Integer Case a10,sum(B1:L1)=0 Month = "Jan" etc.... help is much appreciated - thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shortcut Key Creation | Excel Discussion (Misc queries) | |||
| Spreadsheet Function creation? | Excel Worksheet Functions | |||
| Syntax for Info or Cell function for xl. file creation date | Excel Worksheet Functions | |||
| Function Library Creation | Excel Programming | |||
| Matrix Multiplication Function creation | Excel Programming | |||
Threaded Mode
