Excel letters relation to numbers

Closed
Greg00139 Posts 1 Registration date Saturday October 15, 2011 Status Member Last seen October 15, 2011 - Oct 15, 2011 at 12:54 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 15, 2011 at 08:30 PM
Good evening

I am making an excel spread sheet template for an assignment at college and I have hit abit of a snag. I want to express an answer in grams but I am working in Kg's. Is there a way for the formula to detect the units I'm using and then automatically convert them without me having to manually change anything?

Thanks in advance

Regards

Greg

Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 15, 2011 at 08:30 PM
not clear.

suppose you get the answer in kg in cell F1 . in another cell in the same row you type a formula
=F1/1000
you can even copy down.
0