# Solved Student Data Base

August 20, 2011 at 05:03:08
Specs: Windows XP
 i am trying maintain one student data base using the if and function Fees-100EMI-3Start 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+Dec00Admission taken Sept then emi should Aug00+Sept00+Oct33.33+Nov33.33+Dec33.33+Jan00how to right the formula, please help meHimansu

See More: Student Data Base

#1
August 20, 2011 at 07:40:39
 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 Blue line 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.

Report •

#2
August 21, 2011 at 23:29:00
 I want to send my excel sheet, if it possible ?. i want to chat to explain properly

Report •

#3
August 22, 2011 at 00:16:41
 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.

Report •

Related Solutions