Rounding numbers in a cell with a funtion

R

Randy

I have a cell that has a funtion (sum=A2*A7). This calculates a number like
0.6 or 4.7. I need to be able to round numbers form (0.1 to 4.2) to 4 and
numbers (4.21 to 8.2) to 8. How do I do that?
 
J

Jeff Boyce

Randy

You posted your question to a newsgroup dedicated to Microsoft Access, the
relational database. Your question seems to suggest that you're using
Excel. Have you tried posting to an Excel newsgroup?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paragraph numbering in Word 1
Finding the proper style field and the numbered paragraph value within the style 0
VBA multiple list of values for variable 1
Finding the right style field in VBA 0
Found a Bug or Error in Access 2002-2003 Round Function 3
Can I add a formula or function to Vlookup? 1
Help with lots of formulas 3
if the numbers in sequence 11

Top