excel round equation in sas

[dht115]

Hello, 

I do have following equation in excel. 

=ROUND(((SUM(O206+Q206+S206+U206+W206+Y206+AA206+AC206+AE206+AG206+AI206+AK206)-BK206)/11),0)

Here, Column "O" to Column "AK206" are my dmd data

Column "BK" is my maxtwelve

I use following equation in sas. 

round = round((sum(of Dmd1-Dmd12)-maxtwelve)/11);

In some incident, I am not getting same result. 

For example if Excel produce -66.45454545, Excel Output is -66. Whereas SAS output is -67. 

If I use 

int = int((sum(of Dmd1-Dmd12)-maxtwelve)/11);

In some incident, I am not getting same result. 

For example if Excel produce -463.5454545, Excel Output is -464. Whereas SAS output is -463. 

[Tom · Accepted solution]

Did you check how both system handle rounding of negative numbers?

You could make you own test data to see.

If that does not provide an answer than check the individual pieces.  If you are adding enough numbers the sum of small differences in each could result in values to slip from one side of the up/down dividing line for rounding.