Multiply Different Cells by Different Cells depending on Drop Down Selection
Sorry i dont know how best to phrase this so i will give an example best i can. In attached picture the Columns "Phase of Work" and " Rate" are drop downs. Ive changed the names of actual columns to be non industry specific.
Based on the selection of phase in the drop down at Column A i want it to multiply the rate times the number of units in the corresponding Column C-F and total in the "Amount Paid" Column.
So if the drop down "Phase of Work" has selected Phase 1 I need "Rate" * "Phase 1 Units". If the "Phase of Work" has selected Phase 2 i need "Rate" * "Phase 2 Units" and so forth.
Help Article Resources
Check out the Formula Handbook template!