Forum Discussion
ElliotDT
Apr 16, 2024Copper Contributor
Is it possible for a formula to change depending on the choice from a drop down list
Good Afternoon, Is it possible for a formula to change depending on a drop down list choice? I am trying to create a spreadsheet which removes a lot of admin work. In this example I am trying ...
HansVogelaar
Apr 16, 2024MVP
IF(dropdown="Blank", UnitPrice, GrossWeight*KgPrice)/PartsPerBlow-ScrapReclaim
Substitute the appropriate cell references.