Milade8080
Registered User.
- Local time
- Today, 08:43
- Joined
- Mar 6, 2014
- Messages
- 34
Hi
I need a form to calculate the fines as follows:
TXTBOX1 ---> Specified date to pay taxes
TXTBOX2 ---> Amount of tax
TXTBOX3 ---> Date on which the tax is paid
TXTBOX4 ---> The amount paid for taxes
TXTBOX5 ---> Calculation Date
TXTBOX6 ---> Amount of fines
-----------------------------------------------------------------
IF(AND(TXTBOX1>=TXTBOX3;TXTBOX4=TXTBOX2) ---> TXTBOX6 =0
IF(AND(TXTBOX1>=TXTBOX3;TXTBOX4 TXTBOX6 = (TXTBOX2-TXTBOX4)*0.02*DATEDIF(TXTBOX1;TXTBOX5;"M")
IF(AND(TXTBOX1 TXTBOX6 = TXTBOX2*0.02*DATEDIF(TXTBOX1;TXTBOX3;"M")
IF(AND(TXTBOX1 TXTBOX6 = (TXTBOX2*0.02*DATEDIF(TXTBOX1;TXTBOX3;"M")+((TXTBOX2-TXTBOX4)*0.02*DATEDIF(TXTBOX3;TXTBOX5;"M")
-------------------------------------------------------------
DATEDIF is the distance between two different dates
I need a form to calculate the fines as follows:
TXTBOX1 ---> Specified date to pay taxes
TXTBOX2 ---> Amount of tax
TXTBOX3 ---> Date on which the tax is paid
TXTBOX4 ---> The amount paid for taxes
TXTBOX5 ---> Calculation Date
TXTBOX6 ---> Amount of fines
-----------------------------------------------------------------
IF(AND(TXTBOX1>=TXTBOX3;TXTBOX4=TXTBOX2) ---> TXTBOX6 =0
IF(AND(TXTBOX1>=TXTBOX3;TXTBOX4 TXTBOX6 = (TXTBOX2-TXTBOX4)*0.02*DATEDIF(TXTBOX1;TXTBOX5;"M")
IF(AND(TXTBOX1 TXTBOX6 = TXTBOX2*0.02*DATEDIF(TXTBOX1;TXTBOX3;"M")
IF(AND(TXTBOX1 TXTBOX6 = (TXTBOX2*0.02*DATEDIF(TXTBOX1;TXTBOX3;"M")+((TXTBOX2-TXTBOX4)*0.02*DATEDIF(TXTBOX3;TXTBOX5;"M")
-------------------------------------------------------------
DATEDIF is the distance between two different dates