Hey all,

I have an interesting scenario which has gotten me completely clueless on how to solve. The Excel sheet I am creating is a form used for customer and event information for my DJ business. A cell (let us say A1 for this example) has one of the following three text strings entered into it: "Basic DJ", "Full DJ", or "Complete DJ". Cell "B1" will in turn display a fixed numeric cost, the value of which is determined by the text that was entered in "A1" ($125, $325, $450). Is it possible to do this? Can it be done in a single formula, or would I have to use several "dummy" cells to hold intermediate values and divide the formula into pieces? Any help on this would be greatly appreciated.