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

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?

--
John C. Harris, MPA
JCZ Consulting Services, LLC

"badgercat" wrote in message
...

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

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.


"badgercat" wrote:


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

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



"John C. Harris, MPA" wrote:

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?

--
John C. Harris, MPA
JCZ Consulting Services, LLC

"badgercat" wrote in message
...

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

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

"bj" wrote:

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.


"badgercat" wrote:


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