what do i do to make ="["&J5*0.063&"]" round to the nearest whole number
C CLR Aug 3, 2006 #2 To ROUND a formula result to the nearest whole number, just wrap the formula in a ROUND formula, like....... =ROUND(YourFormula,0) hth Vaya con Dios, Chuck, CABGx3
To ROUND a formula result to the nearest whole number, just wrap the formula in a ROUND formula, like....... =ROUND(YourFormula,0) hth Vaya con Dios, Chuck, CABGx3
