Thread: Absolute value
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default Absolute value

If ABS(dblLocalReturnDiff ) errorMarginal Then...
!
Regards,
Stefi

€˛Sally Mae€¯ ezt Ć*rta:

I have a sub that checks if the contents of cells in two rows are the same.
The cells contain numbers that are paset from another program. If they are
not the same I want to see how big the absolute difference is between the two
cells. I do not know how to write the difference in absoulte terms, so I need
help with that. My code is:
If rng4.Offset(l, 0) < 0 And rng3.Offset(l, 0) Then
dblLocalReturnDiff = rng4.Offset(l, 0) - rng3.Offset(l, 0)
If dblLocalReutrnDiff errorMarginal Then...
It is on the last row that I am interesetd in using the absoulte value for
the difference. Please help me!