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
1864
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

1 reply

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
808
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