Forum Discussion
Solved
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...
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)
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
Thank you for your quick reply!
