=Trend question

J

JAgger1

I have a set of numbers from A1:A10. In cell A12 my formula is
=trend(A1:A10) and get an answer of 5.145454545, I format column A for
number with no decimal places. If I copy and special past (value) to
cell A15, It will show value of 5 in cell, but in formula bar it still
show's value of 5.145454545?? How do I get it so it show's a value of
5 in formula bar instead of 5.145454545?
 
R

Ron Rosenfeld

I have a set of numbers from A1:A10. In cell A12 my formula is
=trend(A1:A10) and get an answer of 5.145454545, I format column A for
number with no decimal places. If I copy and special past (value) to
cell A15, It will show value of 5 in cell, but in formula bar it still
show's value of 5.145454545?? How do I get it so it show's a value of
5 in formula bar instead of 5.145454545?

=round(your_formula,0)

Or you could set Precision As Displayed in the Options, but this will irrevocably change the precision of all your cells.
 
V

Vacuum Sealed

=round(your_formula,0)

Or you could set Precision As Displayed in the Options, but this will irrevocably change the precision of all your cells.

Like Ron said..

=ROUND(TREND(A1:A10),0)

Cheers
Mick
 

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

Top