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 Contact USThanks. We have received your request and will respond promptly. 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 Guidelines |
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! Already a Member? Login |
ResourcesLearn methods and guidelines for using stereolithography (SLA) 3D printed molds in the injection molding process to lower costs and lead time. Discover how this hybrid manufacturing process enables on-demand mold fabrication to quickly produce small batches of thermoplastic parts. Download Now
Examine how the principles of DfAM upend many of the long-standing rules around manufacturability - allowing engineers and designers to place a part’s function at the center of their design considerations. Download Now
Metal 3D printing has rapidly emerged as a key technology in modern design and manufacturing, so it’s critical educational institutions include it in their curricula to avoid leaving students at a disadvantage as they enter the workforce. Download Now
This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. Download Now
|
Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.
Here's Why Members Love Eng-Tips Forums:
Register now while it's still free!
Already a member? Close this window and log in.
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??