If A1 is a number, the result of this formula will be text, though, and cannot easily be used in further calculations that require numbers. If you just want to show the number with the word "Kilos" as a unit, you could simply format the cell with a custom number format, for example...
Share Resources
willbedifferent,itisthe lastcolumnwithnumericaldatainit. 1.TypeAveragein columnA 2.Type =Average(first columnwith numericaldata, lastcolumnwith numericaldata) 3.Hitenter Otherformulastouseare: 1.StandardDeviation:=STDEV 2.Maximum=maximum 3.Minimum=minimum GraphsandExcel TousethegraphfunctioninExcel,...
We use optional cookies to improve your experience on our websites, such as through social media connections, and to display personalized advertising based on your online activity. If you reject optional cookies, only cookies necessary to provide you the services will be used. You...
If A1 is a number, the result of this formula will be text, though, and cannot easily be used in further calculations that require numbers. If you just want to show the number with the word "Kilos" as a unit, you could simply format the cell with a custom number format, for example...