Ad-Free CAclubindia and Daily Updates on your mobile. Subscribe Now!

Doubts in excel

CA. Bhabani , FCA, DISA, DIRM (Chartered Accountant) (205 Points)

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?

Reply
Follow
Share

9 Replies

Dharmendra M.Darji (CA FIRM) (32 Points)
Replied 25 June 2007

USE ROUND FORMULA FOR GOOD RESULT

Upgrade to CAclubindia Pro. Subscribe Now!

Shaily Jain (Chartered Accountants) (1054 Points)
Replied 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)
Replied 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)
Replied 25 June 2007

CA. Bhabani , FCA, DISA, DIRM (Chartered Accountant) (205 Points)
Replied 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?

Upgrade to CAclubindia Pro. Subscribe Now!

tarun (Student) (196 Points)
Replied 27 June 2007

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

Vikram Pandya (CA Business) (12 Points)
Replied 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