If Than

[General 3]

If a column is > or = to another column than subtract if < or = to than add. How do you write this formula?

[bebo021999]

You mean "then"?
Try this:
=IF(A1>=B1,A1-B1,A1+B1)

[sunflowers]

You mean "then"?
Try this:
=IF(A1>=B1,A1-B1,A1+B1)

To bebo021999 @ :Your formula is comparing value of this cell with another cell but the purpose : "Compare value in this column with another column (Alot of cells)"
To General 3 @ : Can you upload your file? So we can see the suggestion and the results you desire.
Thanks!

[sunflowers]

You mean "then"?
Try this:
=IF(A1>=B1,A1-B1,A1+B1)

To bebo021999 @ :Your formula is comparing value of this cell with another cell but the purpose : "Compare value in this column with another column (Alot of cells)"
To General 3 @ : Can you upload your file? So we can see the suggestion and the results you desire.
Thanks!

[General 3]

Thanks all for your help. Trying to Set up a simple inventory process. If beginning qty is 5 ending qty is 3 we'er -2. If beginning qty is 3 ending qty is 5 we'er +2. I could not achive these answers with the formulas provided.

Thank you all for your continued efforts and hope you can come up with a answer. We are a small non profit working with foster kids. Thanks General 3

[AmateurXL]

To bebo021999 @ :Your formula is comparing value of this cell with another cell but the purpose : "Compare value in this column with another column (Alot of cells)"
To General 3 @ : Can you upload your file? So we can see the suggestion and the results you desire.
Thanks!

Hi,

Not quite sure what you mean by value of a column, you can use the formula for a cell and copy it all the way down,
or alternative sum up the columns in a cell and then use the formula. Either way, I think you're going to have to implement the cell formula.

The above is one solution which you can copy down and use,

an alternative preference could be:

This reads as follows; If A2 is > A1 or A2 = A1, then A2 - A1, otherwise A2 + A1

Because if A2 is NOT > A1 or A2 is NOT = A1, then by default A2 HAS TO BE < A1.



Hope that helps.




A X L