« Checkerboard shading | Main | Listing Cell Notes »
September 13, 2005
Basic functions: CHOOSE
The CHOOSE function comes in handy when there are a number of options for a particular value based on the result of an expression or result. It saves having to construct a complex formula involving nested-ifs.In the example below, the CHOOSE function is used to select the text form for the day of the week - according to the numerical value returned by the WEEKDAY function
Posted by Dave at September 13, 2005 09:45 PM