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-down column, but I can't seem to get my head around how to properly put them into an 'IF' statement (or if there is a better way to do it.
Thank you in advance!
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)
- ShelbyYblehsCopper 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) - m_tarlerBronze Contributor
maybe:
=IFS(ISNUMBER(B2), A2-B2, UPPER(LEFT(B2,1))="Y", ROUND( A2/1.13*1.0394, 2), UPPER(LEFT(B2,1))="N", A2, TRUE, "N/A")
or using just IF() and ignoring the "extras"
=IF(ISNUMBER(B2), A2-B2, IF(B2="Y", ROUND( A2/1.13*1.0394, 2), A2)
so the "extras" in the 1st option include allowing Y or y or YES or Yes ... and also checking for the NO or N case and if something else is there giving a "n/a" instead of assuming a NO
- ShelbyYblehsCopper Contributor
Thank you for your quick reply!