I'm trying to get Excel to calculate different mathematical values based on
the user's selection from a drop-down list. The list contains various lengths
of drywall sheets and I want the program to calculate the square footage of
the sheets based on the one selected. Can't figure it out.