calculating the difference between 2 numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know if it is possible to put together a sum that will add up the
difference between 2 numbers in a cell. for example if 28 is in A1 and 38 is
in A2 the sum would give me the answer of 10. This would be simple if the
higher number was always in colum 2 but what happens if instead of 38 in A2
it was 23. The difference would be 15. I dont want any minus figures.

Is this possible or have I confused everyone that reads this?!!!

Darran.
 
Thank you both very much, just what I was after so top marks to the both of
you.

Darran
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Avoiding redundant calculations 7
Calculating the difference between hours 1
Difference between 2 numbers 4
calculate sum between different criteria 4
Difference between two numbers 2
IF AND Nested Functions - Formula Not Working 0
sum of text positions 10
Formula to answer YES or No 4

Back
Top