All cells formatted as General.
A1 = 0.2333
B1 = 15
C1 = A1*B1 the result is 3.5
But if
D1 = 0.2333*15 the result is 3.4995
Why the difference?
How can I get C1's answer to be 3.4995 then be able to ROUND up or down depending on the value of the decimal (3.4995 to 3, or 3.5 to 4)?
George
Ηι
It's format problem...
If in C1,reduce the decimal, you will get your result(3,5).
Then for rounddown & rownup, use these formulae.
=ROUNDDOWN(C1;0)
=ROUNDUP(C1;0)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks