Round sum formula request

[Muthukrishnan V]

Excel 2003 - Column C contains numericals. I want the output of
C15 * 15% (Rounded up), for example if C15 * 15% is 63292.64, I want the output to be 63293 in Column C16. What formula should I use in C16? Please help.

 

[VoG]

Try

=ROUNDUP(B15*0.15,0)

 

[Banker1]

Try

=ROUNDUP(B15*0.15,0)

Note that this formula will round all values up to the next integer (i.e., 6.4 rounds to 7 as does 6.6). If you want to round to the nearest integer use ROUND() therefore 6.4 will round to 6 and 6.6 will round to 7.