Forum Discussion
ShelbyYblehs
Feb 05, 2025Copper Contributor
Drop Down Determines IF Forumula
Hi! I am looking to have a formula in a column change depending on the answer by an adjacent drop down cell. The table below breaks down the formulas I want the cell to use dependent on the drop-dow...
- Feb 05, 2025
For anyone wondering!
This was the answer:
=ROUND(IF(C2="Y",A2/1.13*1.0394,IF(C2="N",A2,IF(C2="Listed",A2-B2,""))),2)
ShelbyYblehs
Feb 05, 2025Copper Contributor
For anyone wondering!
This was the answer:
=ROUND(IF(C2="Y",A2/1.13*1.0394,IF(C2="N",A2,IF(C2="Listed",A2-B2,""))),2)