struggling with this

Posted by Patrick on April 27, 2001 6:51 AM

I have this in cell A3
=IF(A2,(Sheet1!F132=1),"Monday")
it returns Monday in cell A3
The value 1 is coming from a drop down list, which of
course can also....2....3...4...5...6...7
how could this be written to return the
other days of the week

=IF(A2,(Sheet1!F132=1),"Monday")+=IF(A2,(Sheet1!F132=2),"Tuesday")
etc etc ??

from here what I would like to be able to do is
to have cell A4 to be the sum of cell A3+1
to return the next day depending on the result of A3

thanks again
really would appreciate any thoughts on this

Posted by Big Bob on April 27, 2001 8:20 AM

:::::::::
What about formatting the cells A3 and A4 as "dddd" .I think this should work but can't test it as this is an Internet terminal only
HTH

Posted by Patrick on April 27, 2001 8:27 AM

that did it
thanks very much!!!!

Posted by Aladin Akyurek on April 27, 2001 10:52 AM

Patrick

I'm not sure why you test A2, but why not enter in A3

=IF(A2,VLOOKUP(Sheet1!F132,{1,"Monday";2,"Tuesday";3,"Wednesday";4,"Thursday";5,"Friday";6,"Saturday";7,"Sunday"},2,0),""

I'd suggest that you give a meaningful name to F132 on Sheet1 and replace Sheet1!F132 by that name in the above formula.

Aladin