Comments by Member 14076249 (Top 24 by date)

ahhh sorry i just copied it, but i already tried to changed them to decimal and i still get the same result it keeps adding and subtracting the decimal.

[ System Result ]

Principal: 765517.81 Interest: 128000.00 Balance: 24834482.19
Principal: 769345.40 Interest: 124172.41 Balance: 24065136.79
Principal: 773192.13 +1 Interest: 120325.68 Balance: 23291944.66 -1
Principal: 777058.09 Interest: 116459.72 Balance: 22514886.57 -1
Principal: 780943.38 Interest: 112574.43 Balance: 21733943.19 -2
Principal: 784848.09 Interest: 108669.72 Balance: 20949095.11 -1

i tried using Decimal.Round(value,2) yes it resolve the 2nd entry from rounding off but the next problem comes in the 3rd entry

[ Principal: 773192.13 ] and the value that i need to show is
[ 773192.12 ] because that's the result in excel and because it round up for the principal the result in the balance go up

this is the result in excel, you will notice that i put some +1 or -1 -2 that's the result in my system it keeps subtracting or adding i have -0.05 in my balance as the final result

Principal: 765517.81 Interest: 128000.00 Balance: 24834482.19
Principal: 769345.40 Interest: 124172.41 Balance: 24065136.79
Principal: 773192.12+1 Interest: 120325.68 Balance: 23291944.67 -1
Principal: 777058.09 Interest: 116459.72 Balance: 22514886.58 -1
Principal: 780943.38 Interest: 112574.43 Balance: 21733943.21 -2

but where do i put that Decimal.Round(value,2) ?, exatly that's the result that i want but some of the decimal is not the same with the excel, the 3rd entry in the principal should be .12 like in the excel and for the balance 3rd .66 should be .67 like in the excel same goes with fifth entry .20 = .21

but how do i display it what i exactly i want like 769,345.40 not .39

MsgBox i use this for just a sample. hehe

i think i have another problem instead of
773192.12 for the interest i get 773192.13

and for the principal or balance
23291944.66 instead of 23291944.67

sorry i'm using MessageBox class too, but thanks!

yes! i get 769,345.39 instead of 769,345.40 ,the system value is 769,345.39905

i already tried using decimal but i keep getting the same error with the decimal

can you tell me in a simple way how to use Round half up i'm a little bit confused or how do i put it in my program without major changing?

yes i tried using the add watch and for the actual value is 769,345.39905 in my system, by the way this is in for loop so i need to subtract this 31 times or it depends on what i enter. i get the exact result but not for the decimal.

for the result in excel
765,517.81
769,345.40

Result in my system
765,517.81
769,345.39

i have the same computation in excel but my problem is why i don't get the exact value for the decimal.

it don't accept multiple entries or same empid but i want to display it as a message in my program

Bryian, yes empid is primary

what i want is to set a query that checks or display if the data that you have entered is already in the database