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