Thread: I have a complex formula where I need to build in a MAX function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
  
Posts: 834
Default I have a complex formula where I need to build in a MAX function
What is that formula meant to be doing, it looks hugely over-complicated.

--

HTH

Bob

"Nicole Schmidt" wrote in message
...
See this formula, the function is not working in the spreadsheet.
Another
alternative would be to insert a max function - how do I do this?

=SUM((C14-C13)/(L13-J13)*(L12-J12)+J12)*OR(IF(C14<0.6,0,(SUM(((C14-C13)/L13-J13))*(L12-J12)+J12)*(L12-J12)+J12))*OR(IF(C140.9,0.9,(SUM(((C14-C13)/L13-J13))*(L12-J12)+J12)*(L12-J12)+J12))

Help!
--
Nickie


Reply With QuoteReply With Quote