View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JohnJack JohnJack is offline
external usenet poster
 
Posts: 12
Default summing an array of cells absolute value

In quattro, the formula )) would return the maximum
of the absolute values in cells B5 to B200. I am having troubles
finding a function in excel that will do this

basically returning the max of an arrays absolute values. I know I
can create another column doing the individual absolute values and
just take the max of that, but I would think excel would have a
similar function.

Any help would be appreciated.

Jack