Forum Discussion
Need assistance / help determining formula / IF function?
Hello everyone! I'm wholly unfamiliar with the possibilities Excel can provide, so I need help automating an effect I'd like to happen. For my life, I cannot find a similar situation online so I ...
That's exactly as you say
IF column A states "Almost Certain" and Column B states "Minor", C must show the result as "Low"
in C2:
=IF( AND( A2="Almost Certain", B2="Minor" ), "Low", "here are other variants")You may use nested IF() or IFS() for entire set of variants, even better to generate helper table for them and lookup from it.
Thank you for this, it has become clearer as to what went wrong on my end!
What would the formula look like if you have multiple values?
For example Almost Certain + Minor = low ( and Almost Certain + Moderate = Medium etc..), Likely + Minor = low ( or Likely + Moderate = Medium etc..) etc?
Cheers
What would the formula look like if you have multiple values?
For example Almost Certain + Minor = low ( and Almost Certain + Moderate = Medium etc..), Likely + Minor = low ( or Likely + Moderate = Medium etc..) etc?
Cheers
Depends on what "etc" means. You may put the logic into the matrix and pickup values from it; or hardcode in formula, e.g. with nested IF(). But in any case full logic is to be defined.