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?
... 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?