Google Sheet: Automatic line break with formula
Solved
Dawaklawak
Posted messages
84
Status
Member
-
Dawaklawak Posted messages 84 Status Member -
Dawaklawak Posted messages 84 Status Member -
Hello,
I am currently on Google Sheets and I'm struggling to do something:
I have a formula: =(H3*40)/100
And I would like H3 to change according to the row, meaning it should change to H4, then H5, and so on... It's quite complicated, I can send you the link so you can help me in real time if you want?
Let me know in the comments.
Thank you!
I am currently on Google Sheets and I'm struggling to do something:
I have a formula: =(H3*40)/100
And I would like H3 to change according to the row, meaning it should change to H4, then H5, and so on... It's quite complicated, I can send you the link so you can help me in real time if you want?
Let me know in the comments.
Thank you!
1 answer
-
Hello Dawaklawak,
a) In your formula, your parentheses are unnecessary => =H3*40/100
(check the order of operations in an expression).
b) You can also use: =H3*40%
c) If you copy one of these 2 formulas downwards, it will become
=H4*40/100 or =H4*40%; it’s when you use “$” that
it locks the row: =H$3*40/100 or =H$3*40% => copying
down will give the same formula below.
Best regards
-
Thank you for your response and your advice!!!
The problem is that it goes directly to h9 and I feel like it's going to be more complicated.
I'm sending you the link to the Google Sheet, you might understand better...
It's for a game so don't worry if you don't understand the numbers.
https://docs.google.com/spreadsheets/d/1ZegyW_c-9e0QKLpTdATvETGoguhttp://www.commentcamarche.net/forum/affich-34763282-google-sheet-retour-a-la-ligne-automatique-avec-formule#E8foh9pbO6QyWi30s
Thank you! -
-