If, Then Statement....?

[Anthony G.]

Hello To All:

The user will enter data into cells that fall within columns A:C, which will then put the formulas in column D to work. Cells in column E will use Data Validation in order to allow the user to select from a list of disciplines. Currently, cells A10:B13 house the disciplines and their cost, which allows the formulas in column F to work only if done manually. The goal is to place a formula into the cells in column F that would automatically perform the calculation once the user selects the desired Discipline from the drop-down menu...is that possible?

Thanks...Anthony

******** ******************** ************************************************************************>

Microsoft Excel - Book2 ___Running: xl2002 XP : OS = Windows Windows 2000
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
D2F2D3F3D4F4D5D6D7 =
	A	B	C	D	E	F
1	District	Total*Enroll	Grades	Adopt*Enroll	Discipline	Cost
2	Cuba*City*School*District	276	2	79*	Reading	$7,886*
3	Milwaukee*-*Private	85	7	85*	Language*Arts	$6,375*
4	Erin*School*District	266	4	152*	Science	$7,600*
5	Racine	262	6	225*	Reading	*
6	Waukesha*-*Private	220	7	220*	Health	*
7	Grant	79	6	68*	Science	*
8	*	*	*	*	*	*
9	*	*	*	*	*	*
10	Reading	$100	*	*	*	*
11	Language*Arts	$75	*	*	*	*
12	Science	$50	*	*	*	*
13	Health	$25	*	*	*	*
Sheet1 *

[HtmlMaker 2.32] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.