Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 386
  • Last Modified:

Google Docs Spreadsheet ?

I have created a spread sheet that looks something like the below:

Date  Qty  $
xxx      3    6

Total         6

How can I configure the sheet so that when I put in 1,2,3 or whatever in the qty column the $ colum knows that 1 = $2?

Thanks in advance.
0
1namyln
Asked:
1namyln
1 Solution
 
zorvek (Kevin Jones)ConsultantCommented:
Put this formula into cell C2:

=B2*2

and copy down as far as needed.

Kevin
0
 
1namylnAuthor Commented:
Awesome!  Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now