Hi All,
As always, I am after your help....
I have in column H either "ESPS" "LDCS" "NGDB" and in another workbook (called Assumptions I have the above with say "ESPS = 20%" LDCS = "11% and "NGDB = 30%" Assume cells A1 A2 A3
I want a formula that will state that if the cell in H states ESPS it will multiply column B by 20% (from the assumptions workbook)
Hope the above makes sense
As always, I am after your help....
I have in column H either "ESPS" "LDCS" "NGDB" and in another workbook (called Assumptions I have the above with say "ESPS = 20%" LDCS = "11% and "NGDB = 30%" Assume cells A1 A2 A3
I want a formula that will state that if the cell in H states ESPS it will multiply column B by 20% (from the assumptions workbook)
Hope the above makes sense