ROUND() will work; there is a VBA function by that name. ROUNDUP() will not work. Likewise VLOOKUP will not work. My original attempt was to have the function create a string with the appropriate values. However it went into the cell as a string and not as a formula which is exactly the way Excel is supposed to work. If I could have gotten that to work, then you would have your answers.