Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
jkm1317 said:
Is there a way to automatically input a formula for ONE TIME only? I have a sheet where I am using vlookup to calculate a total. (Price*quantity = total). Well as time (years) goes on this price has changed (e.g. inflation). So my issue is that when i change the price all my old calculations would change as well. i would like gdocs to lookup the answer and hold it.
I hope you can help!
Thanks!
------------------------------------------------
jkm1317 said:
Is there a way to automatically input a formula for ONE TIME only? I have a sheet where I am using vlookup to calculate a total. (Price*quantity = total). Well as time (years) goes on this price has changed (e.g. inflation). So my issue is that when i change the price all my old calculations would change as well. i would like gdocs to lookup the answer and hold it.
I hope you can help!
Thanks!
------------------------------------------------
No comments:
Post a Comment