| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| complex color fill conditions- if statements or complex formula? | Excel Discussion (Misc queries) | |||
| Help to build a Look Up Function or What Ever Function Excel 2002 | Excel Worksheet Functions | |||
| build complex formulas using the dialogue box | Excel Discussion (Misc queries) | |||
| <REQ Can anyone help me build a function, please read.... | Excel Worksheet Functions | |||
| complex excel formula Array how do I convert it to a vba Function | Excel Worksheet Functions | |||
Threaded Mode
