Forum Discussion

joanauhc's avatar
joanauhc
Copper Contributor
Oct 13, 2023
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 ...
excel
joanauhc's avatar
joanauhc
Copper Contributor
Oct 14, 2023

HansVogelaar thank you so much Hans! if i have additional criteria, i will just need to expand the table?

 

 

  • joanauhc's avatar
    joanauhc
    Copper Contributor
    Oct 15, 2023
    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!
    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Oct 15, 2023

      joanauhc 

      Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

      • joanauhc's avatar
        joanauhc
        Copper Contributor
        Oct 15, 2023

        HansVogelaar Sure!

         

        https://1drv.ms/x/s!AncfIeFfD02DknLEUHXQ1f4nKQ9O?e=XOmI1C

         

        Thank you so much Hans!

Resources