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 ...
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.