Posted to microsoft.public.excel.programming

external usenet poster

Posts: 169

Creating a Function

If A1 0 AND SUM(A2:A12) = 0 then A13 = Jan
If A2 0 AND SUM(A3:A12) = 0 then A13 = Feb
If A3 0 AND SUM(A4:A12) = 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(a2:a12)=0
Month = "Jan"

etc....

help is much appreciated - thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating a Function	Stu Gnu[_2_]	Excel Worksheet Functions	4	August 31st 07 08:44 AM
Need help creating a function	nander	Excel Discussion (Misc queries)	3	February 20th 06 04:57 AM
Creating a Function	yanf7[_2_]	Excel Programming	5	September 3rd 04 03:17 PM
Creating a Sub Function	No Name	Excel Programming	2	May 18th 04 08:46 PM
Creating a function	Todd Huttenstine[_2_]	Excel Programming	15	December 5th 03 11:38 PM

All times are GMT +1. The time now is 09:54 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us