if statement module use please help

Could someone help - I have more than 7 functions to nest and come to the conclusion to use module with vba. Sorry I cannot get it to work. for example
=If(A1=1,"monday"),IF(A2=2,"Tuesday")).
I have tried modules and are frustated. where can I get step by step help. or can someone attach an example spreadsheet. It would be appreciated.

andrewm

If col A contains the #s 1 to 7, one way to try:

Put in B1, and copy down:
=IF(A1="","",CHOOSE(A1,"Monday","Tuesday","Wednesday","Thursday","Friday","S
aturday","Sunday"))

Col B will return what you want
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"andrewm" <[email protected]> wrote in
message news:[email protected]...
>
> Could someone help - I have more than 7 functions to nest and come to
> the conclusion to use module with vba. Sorry I cannot get it to work.
> for example
> =If(A1=1,"monday"),IF(A2=2,"Tuesday")).
> I have tried modules and are frustated. where can I get step by step
> help. or can someone attach an example spreadsheet. It would be
> appreciated.
>
> andrewm
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=374880
>

Hi. If it's just the 7 items in your example, perhaps:
=TEXT(DATE(2001,1,A1),"dddd")

(no error checking though)
Perhaps the function "VLOOKUP" might work better for your real data.
HTH. :>)
--
Dana DeLouis
Win XP & Office 2003


"andrewm" <[email protected]> wrote in
message news:[email protected]...
>
> Could someone help - I have more than 7 functions to nest and come to
> the conclusion to use module with vba. Sorry I cannot get it to work.
> for example
> =If(A1=1,"monday"),IF(A2=2,"Tuesday")).
> I have tried modules and are frustated. where can I get step by step
> help. or can someone attach an example spreadsheet. It would be
> appreciated.
>
> andrewm
>
>
> --
> andrewm
> ------------------------------------------------------------------------
> andrewm's Profile:
> http://www.excelforum.com/member.php...o&userid=23130
> View this thread: http://www.excelforum.com/showthread...hreadid=374880
>

Think Dana's suggestion of VLOOKUP is much better, albeit according to Excel
help, the index_num in CHOOSE allows one to select one of up to 29 values
<g>
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----

"Dana DeLouis" wrote
> =TEXT(DATE(2001,1,A1),"dddd")
Much neater ! (For the "direct" suggestion to the example in the post)

> Perhaps the function "VLOOKUP" might work better for your real data.
And this is much more apt an answer to the post !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----