Difference between 2 numbers

Peter100 · May 4th, 2002, 06:04 PM

I simply want to calculate the difference between two numbers in A1 & B1

sen_edp · May 4th, 2002, 06:06 PM

are you kidding ?

Peter100 · May 4th, 2002, 06:09 PM

No

if A1 = 20 and B1 = 30 then A1-B1 = -10 and I want it to display the difference as being 10

[ This Message was edited by: Peter100 on 2002-05-04 17:12 ]

sen_edp · May 4th, 2002, 06:13 PM

Hello Peter

try the abs function
Suppose you have the formula in c1

=abs(a1-b1)

Steve Hartman · May 4th, 2002, 06:13 PM

=ABS(A1-B1)

Peter100 · May 4th, 2002, 06:17 PM

Cheers Fellas

I was searcing for Diff or something similar

Brian from Maui · May 4th, 2002, 06:33 PM

Why not just =b1-a1?

Peter100 · May 5th, 2002, 03:40 AM

Because the nest row might have the data reversed and then the problem would be the same

May 4th, 2002, 06:06 PM	#2
sen_edp Board Regular Join Date: Mar 2002 Location: Hellas Posts: 553	are you kidding ? __________________ Best Regards Andreas

May 4th, 2002, 06:13 PM	#4
sen_edp Board Regular Join Date: Mar 2002 Location: Hellas Posts: 553	Hello Peter try the abs function Suppose you have the formula in c1 =abs(a1-b1) __________________ Best Regards Andreas

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 4th, 2002, 06:04 PM	#1
Peter100 Board Regular Join Date: Apr 2002 Posts: 758	I simply want to calculate the difference between two numbers in A1 & B1

May 4th, 2002, 06:09 PM	#3
Peter100 Board Regular Join Date: Apr 2002 Posts: 758	No if A1 = 20 and B1 = 30 then A1-B1 = -10 and I want it to display the difference as being 10 [ This Message was edited by: Peter100 on 2002-05-04 17:12 ]

May 4th, 2002, 06:13 PM	#5
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	=ABS(A1-B1)

May 4th, 2002, 06:17 PM	#6
Peter100 Board Regular Join Date: Apr 2002 Posts: 758	Cheers Fellas I was searcing for Diff or something similar

May 4th, 2002, 06:33 PM	#7
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Why not just =b1-a1?

May 5th, 2002, 03:40 AM	#8
Peter100 Board Regular Join Date: Apr 2002 Posts: 758	Because the nest row might have the data reversed and then the problem would be the same