Forum Discussion

Militus's avatar
Militus
Copper Contributor
Dec 30, 2023
Solved

multiple if scenarios

How can I formulate the following 3 scenarios:    Assuming j9 cannot be yes if k9 is vacant AND my current tab is "Feb" and previous tab is "Jan", how do I formulate the following:    if k9 = "VA...
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Dec 31, 2023

    Militus 

    My apologies, I forgot a double quote.

     

    =IF(K9="VACANT", "", IF(J9="Yes", F9-G9, IF(J9="No", Jan!I9-H9, "")))

HansVogelaar's avatar
HansVogelaar
MVP
Dec 30, 2023

Militus 

In I9:

 

=IF(K9="VACANT, "", IF(J9="Yes", F9-G9, IF(J9="No", Jan!I9-H9, "")))

  • Militus's avatar
    Militus
    Copper Contributor
    Dec 30, 2023
    Thanks. I'm getting an error though: "there's a problem with the formula. Not trying to type a formula", etc.

    =IF(K9="VACANT, "", IF(J9="Yes", F9-G9, IF(J9="No", Jan!I9-H9, "")))

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Dec 31, 2023

      Militus 

      My apologies, I forgot a double quote.

       

      =IF(K9="VACANT", "", IF(J9="Yes", F9-G9, IF(J9="No", Jan!I9-H9, "")))

      • Militus's avatar
        Militus
        Copper Contributor
        Dec 31, 2023
        Wow, I missed that too. Worked like a charm! Thank you!!

Resources