Forum Discussion

Matan_Avishai's avatar
Matan_Avishai
Copper Contributor
Oct 12, 2022
Solved

Add a difference between numbers with minus

Hi,    I want to create a formula that gives the number 2 if two cells are equal, but if the numbers are different - I want to get the difference between them, but in negative form (For example: If...
excel
Formulas and Functions
  • Matan_Avishai's avatar
    Matan_Avishai
    Copper Contributor
    Oct 12, 2022
    Thank you!
    Is there a way to leave this cell blank as long as I don't fill the other two (right now it says 2 because the empty cells are equals..)?
    It's not critical, but I'd like to do it if possible.

    Thanks again!
    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Oct 12, 2022

      Matan_Avishai 

      Yep.

       

      =IF(OR(A1="", B1=""), "", IF(A1=B1, 2, -ABS(A1-B1)))

      • Matan_Avishai's avatar
        Matan_Avishai
        Copper Contributor
        Oct 12, 2022
        You legend. Thank you so much!

Resources