Thread: Maximum Absolute values
View Single Post
  #4  
Old September 23rd, 2008, 07:37 PM posted to microsoft.public.excel.worksheet.functions
David Biddulph
external usenet poster
  
Posts: 8,714
Default Maximum Absolute values
=MAX(ABS(A11)) as an array formula (Control Shift Enter)
--
David Biddulph

"HW" wrote in message
...
I have a set of values in 4 columns that I need to see as positive or
negative. However, I need a 5th column to show me the maximum of the
absolute values of those 4 columns.