Go AD-Free with CAclubindia PRO for Rs 167/Month Only. Subscribe Now!

Doubts in excel

Excel 3005 views 9 replies

CA. Bhabani , FCA, DISA, DIRM

Chartered Accountant

205 Points Posted on 23 June 2007

Hi,

Very often I come across a typical problem while working with excel.For example 1.57+1.57=3.14. If I decrease the decimal I get 2+2=3.Though calculation is correct it appears as if the Balance Sheet is not tallied.Could anybody suggest a solution?

Replies (9)

Dharmendra M.Darji

CA FIRM

32 Points Posted on 25 June 2007

USE ROUND FORMULA FOR GOOD RESULT

Shaily Jain

Chartered Accountants

1054 Points Posted on 25 June 2007

Dharmendra is right use round formula from "Insert" or in address bar just type =ROUND(1.57,0). then you got good result

Shaily Jain

Chartered Accountants

1054 Points Posted on 25 June 2007

Dharmendra is right use round formula from "Insert" or in address bar just type =ROUND(1.57,0). then you got good result

Shaily Jain

Chartered Accountants

1054 Points Posted on 25 June 2007

CA. Bhabani , FCA, DISA, DIRM

Chartered Accountant

205 Points Posted on 25 June 2007

Thank you for the reply.But I want to make changes to entire work sheet and not to a particular cell.Is there any formula?

tarun

Student

196 Points Posted on 27 June 2007

hi, u should show upto one decimal otherwise no remedy for all this

Vikram Pandya

CA Business

12 Points Posted on 10 August 2007

Use following VBA code after selecting a range of your financial statement. Sub Add_Round() For Each xcell In Selection If xcell.Value <> "" Then If IsNumeric(xcell.Value) Then xcell.Value = "=round(" & xcell.Value & ",2)" End If End If Next End Sub