=Trend question

[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?

 

[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.

 

[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