i have a simple formula with 3 cells, the sum of these 3 cells should be zero however the answer im getting is 2.76E-12. i have never experienced anything like this and im 100% sure my formula is correct. the formula i have used is =sum(I12,G12,H13)
thanks for any help
From what I've noticed that's a format issue. Change the cells formatting to numbers instead of general and this should be fine. Let me know if it doesn't work then please give more details and I'll see if I can help.
yes that solved the problem perfectly, thanks very much for your help and speedy reply
No worries buddy
Stanadon,
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Also, since you are pretty new to the forum, you may not be aware that you can say "thanks" to the users who helped you by clicking on the * icon below the post.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks