When you paste it below it should follow the pattern
Looking for some help with a basic formula. I have a spreadsheet that has a name in column A and a balance in column B. My goal is to have column C give me a specific percentage of the cell in column B. Is there a general formula that means "the previous cell in this row" or do I need to manually adjust the formula for each cell in the column?
In C2, put =B2*0.5 (if you want 50%, you can change that to whatever you need). Then copy that cell and paste it to the entire column and it will automatically modify the row numbers as needed.
Or you can paste this into C2 and it will fill down automatically=arrayformula(B2:B*0.5)
Thanks. Ended up putting the formula in and auto filling down the column.
I would like to copy a whole column to paste outside of the spreadsheet, but it only ends up pasting the top cell. Any way to do it?
Is there a way to delete cells on GS mobile?
If you select the cell/cells and do a long press, one of the options should be "clear". If you don't see it make sure you have permission to edit...
A1B2C3
A 1B 2C 3
=A2=A4 Auto fillThen delete them from a:a
=query(importxml("http://www.boxoh.com/?t="&L8,"//div[([member=17672]ID[/member] ='container')]"),"SELECT Col1")
Try this:Code: [Select]=query(importxml("http://www.boxoh.com/?t="&L8,"//div[([member=17672]ID[/member] ='container')]"),"SELECT Col1")(I haven't tried it on mobile but looks like it works on desktop)