Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 -- andrewm ------------------------------------------------------------------------ andrewm's Profile: http://www.excelforum.com/member.php...o&userid=23130 View this thread: http://www.excelforum.com/showthread...hreadid=374880 |
#2
|
|||
|
|||
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","Wednesd ay","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 <atyahoo<dotcom ---- "andrewm" wrote in message ... 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 |
#3
|
|||
|
|||
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" wrote in message ... 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 |
#4
|
|||
|
|||
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 <atyahoo<dotcom ---- |
#5
|
|||
|
|||
"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 <atyahoo<dotcom ---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
error "module not found" | Excel Discussion (Misc queries) | |||
IF Statement | New Users to Excel | |||
Difference in the listing of the New module addition in 2002 version | Excel Discussion (Misc queries) | |||
7+ nested if statement? | Excel Worksheet Functions | |||
Statement | Excel Worksheet Functions |