i am trying maintain one student data base using the if and function

Fees-100

EMI-3

Start Date should be different

IF(AND(U6=X3,U6>=AG3),0,IF(T16<1,2,(IF(T16>1,2,S16/T16))))

Admission taken July then emi should Aug33.33+Sept33.33+Oct33.33+Nov00

Admission taken Aug then emi should Aug00+Sept33.33+Oct33.33+Nov33.33+Dec00

Admission taken Sept then emi should Aug00+Sept00+Oct33.33+Nov33.33+Dec33.33+Jan00

how to right the formula, please help me

Himansu

re: " Admission taken July then emi should Aug33.33+Sept33.33+Oct33.33+Nov00"I have no idea what this means.

I have no idea what any of your "admission" statements mean or how they relate to the formula that you posted.

Keep in mind that we can't see your workbook from where we're sitting so we have no idea what you have in what cells or what you are trying to do.

Please click on the

Blueline at the bottom of this post and read the instructions found via that link. Then post an example of your data and a clear explanation how what you are trying to accomplish.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

I want to send my excel sheet, if it possible ?. i want to chat to explain properly

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.

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History