Subtract Cell A1 from A2 and vice versa

[fjwag3]

New Excel user coming from open office.

Simple subtraction, eg, A1, A2, A2, A1. I need the solution in Cell B opposite the > number.
=IF(E7>E8;E7-E8;"") is the formula in Open Office. The double quotations do not get the job done in excel 2007.

=MAX(A1:A2)-MIN(A1:A2) this formula subtracts and places in the one cell, I need it either/or, adjacent to the > #.

9 3
6

6
9 3

Thanks in advance
FJW3

​

 

[KevCarter]

Please try:

=IF(E7>E8,E7-E8,E8-E7)

 

[fhqwgads]

i havent used open office but it looks like it uses semicolons instead of commas in formulas so replace those.
normally when typing out a formula it provides the proper syntax underneath.

 

[JLGWhiz]

try this

=ABS(E7-E8)

 

[fjwag3]

try this

=ABS(E7-E8)

Looks like a winner, much appreciated!

 

[fjwag3]

NO, I jumped the GUN.... 122
110 12 WRONG

122 12
110 This is what I need.

How do you edit or delete a post in this forum is my next question, ha

 

[fjwag3]

I need the solution next to the LARGER #, the larger # randomly will be in either cell.
So it could be

110
122 12

 

[fjwag3]

Please try:

=IF(E7>E8,E7-E8,E8-E7)

Nope
Here is what I get
122
110 12 Incorrect

122 12 Correct
110

110
122 12 Also Correct

 

[fjwag3]

i havent used open office but it looks like it uses semicolons instead of commas in formulas so replace those.
normally when typing out a formula it provides the proper syntax underneath.
View attachment 20503

You are CORRECT! Of course, I tried your solution LAST. But yes, substitute comma for semi-colon = WINNER.

 

[fjwag3]

=IF(E7>E8;E7-E8;"")

You are CORRECT! Of course, I tried your solution LAST. But yes, substitute comma for semi-colon = WINNER.

=IF(E7>E8,E7-E8,"") Correct Formula, has to be in both adjacent cells, F7 and F8.
=IF(E8>E7,E8-E7,"")


122 12
110

110
122 12