| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking formula
This the formula I have:
=IF(C8=5,100%)*IF(F8=5,5000000) The 5 in each part is a reference to a probability and an impact and both variables go from 1-5 with different values and percentages applied to both. I need this formula to calculate that if for example there was a probability of 1 and an impact of 5 what the assigned value would be and do this for every single combination of values and impacts (25 in total) HELP! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Hyperlink in nested formula not linking | Excel Discussion (Misc queries) | |||
| Formula linking........Help!!!!!!!!!!!!!!! | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Threaded Mode
