Thread: I have a complex formula where I need to build in a MAX function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nicole Schmidt Nicole Schmidt is offline
external usenet poster
  
Posts: 1
Default I have a complex formula where I need to build in a MAX function
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