Forum Discussion

ShelbyYblehs's avatar
ShelbyYblehs
Copper Contributor
Feb 05, 2025

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)

  • ShelbyYblehs's avatar
    ShelbyYblehs
    Copper 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_tarler's avatar
    m_tarler
    Bronze 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

Resources