| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I nest these 3 IF functions?
I need to nest these 3 if functions into 1 cell.
=(J15="X")*(IF(M15<$AB$10,M15*S10,M15*O10) =(K15="X")*(IF(M15<$AB$11,M15*S11,M15*O11) =(L15="X")*(IF(M15<$AB$12,M15*S12,M15*O12) Without excel wanting to multiply all three? All of you have provided great help today? Can this one be tackled too????? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why not nest more than 7 functions in Excel formula??? | Excel Worksheet Functions | |||
| 3 questions about automated c++ com add-in worksheet functions | Excel Worksheet Functions | |||
| # of Functions per cell | Excel Worksheet Functions | |||
| How can I nest more than seven functions in MS Excel? | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Threaded Mode
