Thread: IF Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Janessa Janessa is offline
external usenet poster
 
Posts: 4
Default IF Function

They wouldn't tell me everything the first go-round would they. Thanks boss!

So they actually are looking with a matrix. So D6=Detectiblity, E6=Effect
and F6=Probability. Is there a formula to determine all of these and then
find the total?

Effect(side) Probability(top)
High Mod Low High Mod Low High Mod Low
High 27 18 9 18 12 6 9 6 3
Mod 18 12 6 12 8 4 6 4 2
Low 9 6 3 6 4 2 3 2 1
Low Moderate High
Detectability