Forum Discussion
Solved
Mutiply formula with 3 or more criteria
Hi everyone! I would need your help in teaching me how to obtain the formula that allows me to calculate the Risk Appetite based on several criteria and conditions. There are 3-4 conditions ...
See the attached version.
Create a lookup table like this - I made up some numbers.
You can expand the table if needed.
Use INDEX/MATCH to look up the multiplication factor for a given GP and contract value.
=INDEX($G$3:$I$5, MATCH(A2, $F$3:$F$5), MATCH(B2, $G$2:$I$2))
HansVogelaar thank you so much Hans! if i have additional criteria, i will just need to expand the table?
Yes, indeed!
- Hello Hans!
Sorry to bother again. I have to add on another criteria which is the contract type. I have various contract types which will match the different criteria.
For example, if the contract type is lumpsum, it will be 2% but the difficult part is that there are different names for the contract type. Hence I would like to do a named range but how do i include it within the current formula?
Thank you so much!
