Counting Numbers

[Guest]

I am looking for a formual to calculate the number of whole numbers between a positive and negative numbers
-4 and 16 =2
5 and 12 =
-22 and -8 = 1

Any help would be great

 

[Bob Phillips]

Just subtract one from the other, if I understand you correctly

=B1-A1

example, B1 = 16, A1 = -4, result = 20

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

I am looking for a formual to calculate the number of whole numbers

between a positive and negative numbers.

 

[Andy B]

Hi

To get the difference between -4 (in A1) and 16 (in B1), just use B1-A1. I
hope this helps, but I feel I may be missing something.

Andy.

I am looking for a formual to calculate the number of whole numbers

between a positive and negative numbers.

 

[Andy Brown]

If you're talking integers, assuming your numbers are in columns A & B:

=ABS(A1-B1)

seems to work.

Rgds,
Andy