Doubts in excel

3126 views
User Avatar

Chartered Accountant
134 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?

Reply Share Follow
On 23 June 2007 at 10:47 Report
Replies (9)
User Avatar

CA FIRM
30 Points Posted on 25 June 2007
USE ROUND FORMULA FOR GOOD RESULT
Reply
On 25 June 2007 at 02:53
User Avatar

Chartered Accountants
523 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
Reply
On 25 June 2007 at 05:08
User Avatar

Chartered Accountants
523 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
Reply
On 25 June 2007 at 05:08
User Avatar

Chartered Accountants
523 Points Posted on 25 June 2007
Reply
On 25 June 2007 at 05:08
User Avatar

Chartered Accountant
134 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?
Reply
On 25 June 2007 at 05:49
User Avatar

Student
196 Points Posted on 27 June 2007
hi, u should show upto one decimal otherwise no remedy for all this
Reply
On 27 June 2007 at 04:45
User Avatar

CA Business
23 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
Reply
On 10 August 2007 at 09:26
User Avatar

Chartered Accountant - Product Manager
455 Points Posted on 20 September 2007
Mr. Vikram Pandya... Very good Suggestion.. it will be a great help to him... thnks..
Reply
On 20 September 2007 at 15:22
User Avatar

Chartered Accountant
86 Points Posted on 09 June 2008

Very good macro by Vikram.....

Just that in the code....last Endif must be deleted....only one Endif is enough..

This macro can be kept as a toolbar icon...so that we can use it by just clicking on it....

Regards,

gurusanthanam

Reply
On 09 June 2008 at 23:33

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Recent Topics :

  1. Consultation
  2. E-way notices2222
  3. Gst file not created
  4. Regarding 3CEB query
  5. Omitted E-Commerce Sales Reported in Table 14 but
  6. Omitted sales shown in GSTR-1 Table 14 but not in
  7. EWAY BILL TAKE OUT OF OTHER COMPAMY
  8. Penalty &amp; late fee for late ITR filing
  9. Business discontinued as Government took possessio
  10. Which Aviation Services Can Air Ticketing Professi

More recent discussions | Post

Related Topics :

Loading

Latest Job Openings

View all
Company
ARTICLESHIP 16 September 2026
Article Assistant

MANUJ SHARMA AND COMPANY

Noida

CA Inter

View Details
Company
30 September 2026
Senior Accounts Executive

Codeboard Technology

Chennai

MBA

View Details
Company
ARTICLESHIP 28 September 2026
Junior Accountant

J S P M & Associates LLP

Pune

B.Com

View Details
Company
09 September 2026
SENIOR AUDITOR & ACCOUNTS MANAGER

Anupam Parashar & Co.

Ghaziabad

CA Final

View Details
Company
ARTICLESHIP 18 September 2026
Industrial Trainee

Twenty Point Nine Five Ventures Private Limited

Noida

CA Inter

View Details
Company
05 October 2026
Senior Accountant

Vision IT Peripherals Pvt Ltd

Mumbai

B.Com

View Details
Company
17 September 2026
Chartered Accountant

Dass Gupta & Associates

Gurgaon

CA

View Details
Company
ARTICLESHIP 16 September 2026
CA Article Trainee

SR BAGAI & Co.

New Delhi

CA Inter

View Details