Just a simple excel question really
Trying to get the values out from a LINEST and LOGEST equation and when I enter in one cell it gives me only the 'm' variable. I can not fo rthe life of me work out how to set this up to give me the result in an array so I get the c values and the R^2.
The excel help says select a range of cells and type in the formula; done that but I still onyl get it in one cell.
Can anyone enlighen me on this?
Thanks
Trying to get the values out from a LINEST and LOGEST equation and when I enter in one cell it gives me only the 'm' variable. I can not fo rthe life of me work out how to set this up to give me the result in an array so I get the c values and the R^2.
The excel help says select a range of cells and type in the formula; done that but I still onyl get it in one cell.
Can anyone enlighen me on this?
Thanks