Xl main disimal number ko real number main kassy badalay

[tak_shaheen]

Dear Sir,
XL Programm min jb hum auto sum kartay hain to figur min shamal decimal ka data bhi total main shamal ho ja ta hay misal ky tor pr 10.60 ka jb hum decimal hatatay hain to who 11 ban ja ta hay
asi wajah sy jb hum mukamal total karty hain to who dicimal kay sath nazar aata hay. mera problum hay hay kh as total ko real number main jb register pr write kartay hay to dicimal shamal nahai katy to figure aur total main 1 ya 2 ka difference aa jata hay .
main ya chahta hoon ko main dicimal number ko real number main mukamal convert kar doon jis ky total main dicimal shamal nahi ho kia assa ho sakta hay koi formula batay thanks.

[Hoor-e-Aine]

i think aap ki problem iss se hal ho jaye gi

Precision as Displayed
In some cases, you may be able to prevent rounding errors from affecting your work by using the Precision as displayed option. This option forces the value of each number in the worksheet to be the displayed value. To turn on this option, follow these steps:
In Excel 2003 and in earlier versions, click Options on the Tools menu.
On the Calculation tab, click to select the Precision as displayed check box.
In Excel 2007, click the Microsoft Office Button, click Excel Options, and then click the Advanced category.
In the When calculating this workbook section, select the workbook you want, and then select the Set precision as displayed check box.
For example, if you choose a number format showing two decimal places and then turn on the Precision as displayed option, all accuracy beyond two decimals will be lost when you save your workbook. This option affects the active workbook including all worksheets. You cannot undo this option and recover the lost data. It is recommended that you save your workbook prior to enabling this option.

(Source: Microsoft)

[syar]

salam::

be careful before using "precison as display" as described by hoor-e-aine
try it

a1=1.1
a2=1.2
a3=1.4

a4 enter this forumla. Its will ignore decimal part and sum real number

=SUMPRODUCT(ROUND(A1:A3,0)+0)

regards

[tak_shaheen]

Thanks syar bhai ya acha tareeqa hay thanks