Hello
I am a new user of Excell 2007.
I have A1, B1, C1(c1 is sum of A1 and B1) with decimal place zero, and
when I put 25.6 in A1, 35.6 in B1, the value is 26 in A1, 36 in B1 and 61 in C1.
This is not what I want.
How Can I make 62 in C1?(26 plus 36 is 62, not 61)
Thanks for help
Try this:
=round(a1,0)+round(b1,0)
- Moo
Thanks
Because I just leave A1 and B1 as blank for user input and get the value of C1,
Is there any other way to manipulate C1, not A1 or B1?
Thank you all
I sholved the problem.
Maybe
=ROUNDUP(A1,0)+ROUNDUP(B1,0)
HTH
Regards, Jeff
You'd have to use =ROUND(A1,0)+ROUND(B1,0) in cell C1
ROUND(A1,0)=26; ROUND(B1,0)=36; so C1 = 62
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
@Jeff: I think the OP just need ROUND rather than ROUNDUP as setting the decimal places to 0 effectively rounds. 25.2 would display as 25, 25.5 and above would display as 26.
Regards, TMS
The formula goes in C1 instead of the simple SUM. You don't need to do anything to A1 or B1
Regards, TMS
You solved the problem? Good
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
The formula: =round(A1,0)+round(b1,0) does not change data entered in cells A1 or B1. It pulls the value from those cells, rounds each one, then adds them together and displays that result in C1, leaving the original numbers intact.
- Moo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks