|My query is I am maintain student database, batches are different.|
If one student taking admission
EMI formula = Total Fees-x & EMI-Y then formula is IF(Y>=1,x/y) 1st Installment, 2nd One is IF(y<2,0,IF(y>=2,x/y)) & 3rd IF(y<3,0,IF(y>=3,x/y))
But my problem is student EMI should be different month then I want to give the date formula also, if student EMI start August then my formula is likeIF(AND(y<1,x/y)) 2nd one is IF(AND(y<2,0,IF(y>=2,x/y))
When I enter the emi start date then emi should start the same and end how many month I am given.