Go AD-Free with CAclubindia Pro and Daily WhatsApp Updates. Subscribe Now!

Doubts in excel

Excel 2850 views 9 replies

CA. Bhabani , FCA, DISA, DIRM

Chartered Accountant

205 Points Joined March 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 Joined June 2007

USE ROUND FORMULA FOR GOOD RESULT

Shaily Jain

Chartered Accountants

1054 Points Joined 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 Joined 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 Joined June 2007

CA. Bhabani , FCA, DISA, DIRM

Chartered Accountant

205 Points Joined March 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 Joined June 2007

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

Vikram Pandya

CA Business

12 Points Joined March 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