I would like to find out a formula to first determine if the coporation listed in Table C exist in Table A and then based on that calculate revenue using the formual IF(B12>B6,B6*C6+((B12-D6)*E6),B12*C6) in Table C based on Amount provided in Table B .
I would like to have this calculation automated through the formula so I don't have to provide change the cell reference for each a new member is added in all tables or taken out.
I would like to have this calculation automated through the formula so I don't have to provide change the cell reference for each a new member is added in all tables or taken out.
