I have a calculation based on the following formula viz..
Rev = A*B*C*D
For each metrics B,C and D if radio button is selected as YES, then we would take the values from one table for that metrics, else from another table.
Also the rev column calculation needs to be calculated from the metrics column selected.
The final output needs to be the following columns
A B C D Rev
Would you be able to post a screenshot or a packaged workbook so I can get a better understanding of what you're trying to do?