If/Then with multiple cells help

[csutton]

My worksheet looks like this:

... C D E F
Complete # # #
Building # # #
Burning # # #
New # # #

Each time "Complete" is marked in column C I need for column F to be 0, but when C is marked as one of the other options, the values for column F depend on the values in columns D and E. If the numbers in column D and E are more than 64 combined, than column F will be = .66 but if column E by itself is = to more than 34 then column F will be = .5. For any lesser value combination, column F will be = .33.

I know how to do each of these if/then's separately, but I do not know how to combine them within one cell... is this even possible?

 

[stilesbn]

See if this works

=IF(C2="Complete", 0, IF(E2>=34,0.5,IF((E2+D2)>64,0.66, 0.33)))

 

[csutton]

Seems to do the trick!

Thanks so much!!!

 

[texasalynn]

not sure I am following, this starts the first two conditions

Excel Workbook
	C	D	E	F
1	Complete	Amt1	Amt2	Is Complete
2	1	55	9	0.66
Sheet2

Excel 2003

Cell Formulas
Range	Formula
F2	=IF(C2="X",0,IF(SUM(D2:E2)>=64,0.66,0))