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