Forum Discussion
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
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
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)
2 Replies
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)
- Thank you
