I need to write a formula where it rounds to the nearest whole percentage, i.e. 6.88% to 7%, or 93.12% to 93%. I then want to use that cell and the rounded percentage in future calculations. How do I tell excel to use the rounded percentage from there. HELP!