cdbl - Postet den (1130 Views)
Starting Member
Fromafarr
Innlegg: 7
7
Hi, When my script adds 100.01 and 100.20 together it produces 200.21 but if it adds 100.00 and 100.00 it produces 200 .I need it to produce 200.00. I am sure i am missing something. I am using cdbl to format my vaiable. Thanks in advance.<
   
 Sidestørrelse 
Postet den
Advanced Member
Carefree
Innlegg: 4224
4224
Use the command "FormatNumber(<your variable>,2)"<
Postet den
Starting Member
Fromafarr
Innlegg: 7
7
Thanks for that. I now have to add together my variables i.e FormatNumber(total1,2)+FormatNumber(total2,2) but get to many .00 returned.<
Postet den
Forum Moderator
AnonJr
Innlegg: 5768
5768
I think he was telling you to use FormatNumber on the result, not on each number as you add it.<
 
Du må legge inn en melding