=Trend question

  • Thread starter Thread starter JAgger1
  • Start date Start date
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?
 
=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.
Click to expand...

Like Ron said..

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

Cheers
Mick
 
Back
Top