| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I combine the 4 IF formulas into 1 formula
K1=IF(D1<0,1,0)
L1=IF(F1<0,1,0) M1=IF(H1<0,1,0) N1=IF(SUM(K1:M1)=0,0,1) O1=IF(A1=MTH,N1,0) Assistance required. How can the formula in O1 combine K1,L1,M1,N1. It is a simple formula, but I admit I am not able to get it right at all even after looking through several examples posted in this forum. Thank you. RobertR |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to combine cells using if/then | Excel Worksheet Functions | |||
| Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
| Formulas appear in cell instead of formula result | Excel Worksheet Functions | |||
| How can I combine IF, COLUMN, and LARGE formulas in a single cell? | Excel Worksheet Functions | |||
| Tricky formulas needed | Excel Worksheet Functions | |||
Threaded Mode
