| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Nesting Networkdays function inside and If function | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Threaded Mode
