Hi
please see small sample attached
i have a drop down in B1
which changes to BTC and BTS
i have hours in columns E to H
in columns I to L i want the monetary value
so when i choose the drop down it should multiply these hours by the daily rate (in rows 15 and 16) based on what the drop down says
can someone help with an if condition with three conditions?
Bookmarks