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
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