using more than 1 formula in a cell

[Guest]

In cell C, I have a formula the divides cell A, by cell B. =sum(A1/B1)
this gives me a number with several decimal places. x.abcdefgh

I would like to be able to round this number to the nearest single digit.

I found the formula =round(C1,0). I'm pretty sure that's what I want.
I do not want to add another colume to my spreedsheet

How do I combine these two formulas into one cell?

Thanks in advance for your help
BadgerCat

 

[John C. Harris, MPA]

The easiest thing to do is not use it as a formula, but set the cell
properties. On the tool bar, with the cell selected, you should see a
buttong to move the decimal place. Click it until it is what you need.

Why do it the hard way?

 

[Guest]

you don't need to use the sum function to do this

=round(A1/B1,0)
you could set the display to appear as rounded, but if you need the rounded
number to do something with as a rounded number, setting display only can
give you problems.

 

[Guest]

That certainly changes the way the number is displayed, but does not change the
characteristic of the number. it is still multiplying the next number by
x.abcdefg

 

[Guest]

Thank you very much "bj".
as usual a simiple solution is all I needed.