In the attached file in column C if string equal keshav then value of cell J8 copied to cell M8,
I want that when copying value of cell J8 Round up that value if decimal value is equal or greater 50,
it means if value in cell J8 is 48.57 then, when copying value should become 49
you can see before after sheet.
You could use the ROUND function in your code like this :
Please Login or Register to view this content.
Even a little help can be a big help !!
1. A sample workbook says more then words. Add problem description and solution so we can understand the problem.
2. Your appreciation is accepted by clicking the star "Add Reputation" at the lower left of the post.
3. If your problem is solved, mark it as [SOLVED]: See "FAQ : " https://www.excelforum.com/faq.php
4. Use [CODE] [/CODE] tags to illustrate your code: see here
Kind regardsPlease Login or Register to view this content.
Leo
thanks for solution, now my problem is solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks