Simple question. I'm working in Excel 2007, and I want to convert 1000 grams into 1 kilogram when I input 1000g into a particular cell. So I decided to create the if statement below. However there is a problem with this. It's stating that it is a Circular Reference, and leaves me with a 0 value. Is there a simple way to fix this issue in excel?
Here is the if statement I have.
=IF(C8 >= 1000,CONVERT(C8,"g","k"),C8)
Tell what you guys think.
Thanks in advance.