Hi,
I am looking for a formula that calculates numbers differently based on the text in column A.
I need to have a summary calculation with multiple criteria for each employee ID. For every employee either External or internal rating will be provided.
If External data is avaialble, then the calculation should be (.7*external+.2*Self+.1*Internal) (ex. formula in column H11) If external data is not available then I would like it to be (.7*self+.3*Internal) (Ex.formula in column C11)
The challenge I am having is there are three rows for each employee ID, so I need to find a formula that combines MATCH and IF function.(or anything other formula that looks up employee IDs and then calculates based on the criteria)
I would like to get the result shown in row 11 and 12.
I am looking for a formula that calculates numbers differently based on the text in column A.
I need to have a summary calculation with multiple criteria for each employee ID. For every employee either External or internal rating will be provided.
If External data is avaialble, then the calculation should be (.7*external+.2*Self+.1*Internal) (ex. formula in column H11) If external data is not available then I would like it to be (.7*self+.3*Internal) (Ex.formula in column C11)
The challenge I am having is there are three rows for each employee ID, so I need to find a formula that combines MATCH and IF function.(or anything other formula that looks up employee IDs and then calculates based on the criteria)
I would like to get the result shown in row 11 and 12.