Jump to content

Need Help w/ Google Sheets

xwboy
 Share
Go to solution Solved by jj9987,

Type =CX/500 (where X is the row number) into the column D cell.

Type =CX/1500 (where X is the row number) into the column E cell.

 

If you need to expand in to other rows, just copy-pasta or copy by dragging the cell from the bottom-right corner.

Posted

Hi!

 

I'm trying to make a spreadsheet to organize a raffle for a guild in an MMO. I've never used Google Sheets before so I'm very confused and need help. All I want to do is take the value in row X, column C, divide it by 500, and output that value to column D. I then want to divide the value in column row X column c by 1500 and output that value to column E. I'm sure there's a simple way to do this but I don't know how. Any help is appreciated!

 

Thanks!

Link to comment
Share on other sites
Link to post
Share on other sites
Posted
  • Solution

Type =CX/500 (where X is the row number) into the column D cell.

Type =CX/1500 (where X is the row number) into the column E cell.

 

If you need to expand in to other rows, just copy-pasta or copy by dragging the cell from the bottom-right corner.

HAL9000: AMD Ryzen 9 3900x | Noctua NH-D15 chromax.black | 32 GB Corsair Vengeance LPX DDR4 3200 MHz | Asus X570 Prime Pro | ASUS TUF 3080 Ti | 1 TB Samsung 970 Evo Plus + 1 TB Crucial MX500 + 6 TB WD RED | Corsair HX1000 | be quiet Pure Base 500DX | LG 34UM95 34" 3440x1440

Hydrogen server: Intel i3-10100 | Cryorig M9i | 64 GB Crucial Ballistix 3200MHz DDR4 | Gigabyte B560M-DS3H | 33 TB of storage | Fractal Design Define R5 | unRAID 6.9.2

Carbon server: Fujitsu PRIMERGY RX100 S7p | Xeon E3-1230 v2 | 16 GB DDR3 ECC | 60 GB Corsair SSD & 250 GB Samsung 850 Pro | Intel i340-T4 | ESXi 6.5.1

Big Mac cluster: 2x Raspberry Pi 2 Model B | 1x Raspberry Pi 3 Model B | 2x Raspberry Pi 3 Model B+

Link to comment
Share on other sites
Link to post
Share on other sites
Posted
  • Author
5 minutes ago, jj9987 said:

Type =CX/500 (where X is the row number) into the column D cell.

Type =CX/1500 (where X is the row number) into the column E cell.

 

If you need to expand in to other rows, just copy-pasta or copy by dragging the cell from the bottom-right corner.

This worked! Thank you!

Link to comment
Share on other sites
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing Programs, Apps and Websites

×