Max absolute value comand??
Max absolute value comand??
(OP)
Is there a comand to get the Max absolute value for a group of numbers. ie
1, 6, -14, 7 = 14
1, 6, -14, 7 = 14
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
Max absolute value comand??
|
Max absolute value comand??Max absolute value comand??(OP)
Is there a comand to get the Max absolute value for a group of numbers. ie
1, 6, -14, 7 = 14 Red Flag SubmittedThank you for helping keep Eng-Tips Forums free from inappropriate posts. Reply To This ThreadPosting in the Eng-Tips forums is a member-only feature.Click Here to join Eng-Tips and talk with other members! |
ResourcesWhat is rapid injection molding? For engineers working with tight product design timelines, rapid injection molding can be a critical tool for prototyping and testing functional models. Download Now
The world has changed considerably since the 1980s, when CAD first started displacing drafting tables. Download Now
Prototyping has always been a critical part of product development. Download Now
As the cloud is increasingly adopted for product development, questions remain as to just how cloud software tools compare to on-premise solutions. Download Now
|
RE: Max absolute value comand??
{=MAX(ABS(A1:A4))}
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: Max absolute value comand??
Thanks, but the problem is that the values arn't in the same column or row.
RE: Max absolute value comand??
=MAX(ABS(A1),ABS(B4),ABS(E19),....)
jproj
RE: Max absolute value comand??
Function MaxAbs(ParamArray R() As Variant)
Dim C As Variant, V As Double
V = 0
For Each C In R
If Abs(C.Value) > V Then V = Abs(C.Value)
Next C
MaxAbs = V
End Function
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: Max absolute value comand??
RE: Max absolute value comand??
RE: Max absolute value comand??
=MAX(MAX(A1:A4),-MIN(A1:A4))
RE: Max absolute value comand??