here is my function on adding 5 results:

Function Add (CdblS, CdblS2, CdblS3, CdblS4, CdblS5, CdblS6)
Add = ((CdblS + CdblS2 + CdblS3 + CdblS4 + CdblS5 + CdblS6)/6)
End Function

Some results are whole number, but some are not. I want to keep all results in the ADD function whole number.

many thanks

Use the ROUND function to first round your double (decimal) values to whole numbers. If you don't want to round the numbers, also take a look at the CEIL and FLOOR methods.

thanks