using more than 1 formula in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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?
 
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.
 
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
 
Back
Top