[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 384
  • 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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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