How to usage RoundUp-RoundDown in Excel

[Faozan]

I have a number set input to excel by number is 165.78 to 166 or 164.32 to 164

Dim cRow

Sheet1.Cells(cRow, 7) = Trim(Mid(Textline,1,6))
If Len(Sheet60.Cells(cRow,7)) = 10 Then
--->
Else
--->
End If

Please help me to answer

 

[Joe4]

Your question is very confusing/unclear. I do not see what your VBA code has to do with your question title.
Perhaps it would be better for you to SHOW us what you want to do.
Please show us a sample of your data to begin with, and then show us what you want your expected results to look like.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[Faozan]

Your question is very confusing/unclear. I do not see what your VBA code has to do with your question title.
Perhaps it would be better for you to SHOW us what you want to do.
Please show us a sample of your data to begin with, and then show us what you want your expected results to look like.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

How to excel by number is 165.78 to 166 and 164.32 to 164

 

[Joe4]

Use the ROUND function to round off the number to the nearest whole number.
The ROUND function exists in both Excel and in VBA, and works the same.

MS Excel: How to use the ROUND Function (VBA)

This Excel tutorial explains how to use the Excel ROUND function (in VBA) with syntax and examples. The Microsoft Excel ROUND function returns a number rounded to a specified number of digits. Please note that the WS version of the ROUND function has different syntax.

www.techonthenet.com

 

[Faozan]

Use the ROUND function to round off the number to the nearest whole number.
The ROUND function exists in both Excel and in VBA, and works the same.

MS Excel: How to use the ROUND Function (VBA)

This Excel tutorial explains how to use the Excel ROUND function (in VBA) with syntax and examples. The Microsoft Excel ROUND function returns a number rounded to a specified number of digits. Please note that the WS version of the ROUND function has different syntax.

www.techonthenet.com

Please show example to me

 

[Joe4]

Did you look at the link I sent?
It shows examples there.

Here is a link to the wroksheet function ROUND versus the VBA one in the previous link.

ROUND function - Microsoft Support

Syntax: ROUND(number, num_digits)

support.microsoft.com

Take some time to look at it and read through the links.