 Search the Knowledgebase |
 Browse by Category |
|
|
|
| How can I round data values in the worksheet? |
| User Opinions |
100%
0%
|
|
Thank you for rating this answer.
|
To remove the decimals from the data permanently, perform a transform on the data. You can do this with the Data |
Transform command in the Surfer worksheet. Use the FLOOR or CEIL function in Surfer's worksheet
or ROUND in Excel.
The CEIL function returns the next integer greater than or equal to the original value.
The FLOOR function returns the next integer less than or equal to the original value.
For example, to round to 0
decimal places, use one of the following transforms:
A = FLOOR ( A + 0.5 ) A = CEIL ( A - 0.5)
To round to one decimal place, you can use one of the following transforms:
A = FLOOR ( (A*10) + 0.5 ) / 10 A = CEIL ( (C*10) - 0.5) / 10
|
| Visitor Comments |
|
No visitor comments posted. Post a comment
|
| Attachments |
|
No attachments were found.
|
Print this page
Email this page
Post a comment