Forum Discussion

Brendan_Wilson's avatar
Brendan_Wilson
Copper Contributor
Sep 09, 2021
Solved

Formula

Hi I need help with formula, don't have much experience. I need the difference tab J2 to either calculate the difference between cell F2 or G2 depending if one isnt zero Thank you
  • Riny_van_Eekelen's avatar
    Sep 09, 2021

    Brendan_Wilson If you mean to say that either F2 or G2 may be zero, but they may not be unequal to zero at the same time, then you can use in J2:

     

    =I2-SUM(F2:G2)