| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
=Trend question
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Challenging question: add TIME TREND in Excel with built-in functi | Excel Discussion (Misc queries) | |||
| Trend question | Excel Worksheet Functions | |||
| Trend function question | Excel Discussion (Misc queries) | |||
| Using Trend | Excel Discussion (Misc queries) | |||
| trend | Excel Discussion (Misc queries) | |||
Threaded Mode
