Hi
I urgently need a formula to round up some data as follows.
If data is entered in a cell is 1.1 or less then add one to make my desired result 2
If data is entered in a cell or 1.4 or greater add two to make my desired result 3
Please note I want to be able to round up using decimal places i.e If decimal place is 0.1 then add one
and if the decimal place is 0.4 then add two.
Thanks in advance
Last edited by cdmterence; 09-18-2013 at 01:45 PM.
Please Login or Register to view this content.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Thanks for the code but its not working
Last edited by cdmterence; 09-18-2013 at 01:51 PM.
There was a typo in the formula (semi-collon instead of comma).
Please Login or Register to view this content.
oeldere the code still isnt working
Show the file, without confidential information; the formula is working (I tested it).
=if(a2>0.1,int(a2)+2;int(a1)+1)
Probably change the comma in a dot.
Error.png
This is the error I am getting it highlights on the 2 and won't evaluate anything
oh now it works, but it doesn't work correctly.
I want it to add conditionally using the decimal place i.e if the decimal is 0.1 or 1.1 or 100.1 I want it to add one to the number.
eg 0.1 = 1
1.1 = 2
100.1 = 101
then if the decimal place is above 0.4 or 1.4 or 100.4 it must add 2
the results must be
0.4 = 2
1.4 = 3
100.4=102
Of course also the second option A2 (instead of a1).
Please Login or Register to view this content.
Sorry its not working
Add an excel file, without confidential information.
I will add the formula in the sheet.
How about =ROUND(A1+1.1,0)
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
i have uploaded excel sheet
is there anyway to nest the formulae
Thanks for the code but it doesnt work
See I want excel to round up using the decimal say if the decimal i.e the number after the dot
number after dot is 1 then add one
number after dot is 4 then add two
See the green cells in the attached file.
=if(D6-INT(D6)>=$F$3,INT(D6)+2,INT(D6)+1)
and drag down.
Last edited by oeldere; 09-18-2013 at 03:17 PM.
oeldere!
Awsome it works wonderfully thank you so much for sticking it out!!!
Thnks oeldere awsome thanks for sticking it out!!!
I agree with the answer. However, when tried this, it failed.
It took some time but on my laptop the result of
1000.4 "D6-INT(D6) " resulted in .39999999999997700000 instead of .4
1.4 resolved to .4
10.4 resolved to .4
100.4 resolved to .4
but 1000.4 resolved to .39999999999997700000
any clues as to why my particular PC can't subtract correctly ?
Last edited by toolman_dustin; 09-18-2013 at 06:22 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks