Current location - Loan Platform Complete Network - Loan consultation - Excel ladder calculation formula asks God for help, and I have to do several formulas well, which is really too difficult!
Excel ladder calculation formula asks God for help, and I have to do several formulas well, which is really too difficult!
Suppose the data is in cell A 1

Question: B 1 cell formula = if (a 1

Second question: B 1 cell formula = if (a 1

After the data comes out, which number or cell you want to multiply can be written into the formula yourself. For example, multiply the cell itself by A 1. Formula = if (a 1