You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Hello Guys,
I'm trying to make a dynamic flow to not repeat the formula in each cell, every time.
Imagine in A2 I give formula of =A1*10 , now in C1, I wanna get the result of A2 by telling what's the supposed value for A1.
Example: in C1 I wanna tell : Suppose that A1 is 5, then give me the result of A2 ( 5*10).
C1 must show 50.
MacBook Air 13″, macOS 12.3
In Numbers, a cell can contain an inserted value, placed there by the user, OR can contain a formula and display the result of that formula. Inserting a value (eg. a number) into a cell containing a formula replaces the formula with the entered value.
Formulas can 'pull' information from other cells, but cannot 'push' information to other cells.
Formulas can return calculation results only to the cell containing the formula.
You want to enter a value (eg. 5) in cell B1 and see the result of multiplying that value by 10 in the same cell.
to do that, you will need to enter the value in the formula, not directly into the cell, which will simply replace the formula in that cell with the entered value.
Here are the steps you could use to accomplish that result.
Cell A1 can be ignored.
Click on cell B1 to select it.
Press = to open the Formula editor.
In the editor, enter B1*10
The editor will immediately change the * to a multiplication sign.
Click the green checkmark button to confirm the formula and close the editor.
Cell B1 will display an error triangle.
To use this setup to do what you want:
Double click cell B1 to select it and open the Formula Editor.
Click on the B1 token to select it.
Type the number you want to 'suppose'
Click the green checkmark button to confirm the formula, close the editor, and view the result.
To see the result for a different 'supposed' number:
Double click cell B1 to select it and open the Formula Editor.
Click on the current number (5) to select it.
Type the new number you want to 'suppose'
Click the green checkmark button to confirm the formula, close the editor, and view the result.
You asked to:
This set of steps lets you do that, but it does require that you spoon feed the formula with each new number rather than just placing the number into a cell.
It returns the appropriate result to the same cell as you placed the new number, provided you put that number in place of the previous number, and did not damage any other part of the formula.
It lets you keep 'the same formula' but requires that you change one of the values placed in that formula to make a change in the result.
Personally, I think you'll find it easier (and likely more accurate) to use 'what you don't need' with the entry cell separated from the calculation cell containing the formula.
Regards,
Barry
In Numbers, a cell can contain an inserted value, placed there by the user, OR can contain a formula and display the result of that formula. Inserting a value (eg. a number) into a cell containing a formula replaces the formula with the entered value.
Formulas can 'pull' information from other cells, but cannot 'push' information to other cells.
Formulas can return calculation results only to the cell containing the formula.
You want to enter a value (eg. 5) in cell B1 and see the result of multiplying that value by 10 in the same cell.
to do that, you will need to enter the value in the formula, not directly into the cell, which will simply replace the formula in that cell with the entered value.
Here are the steps you could use to accomplish that result.
Cell A1 can be ignored.
Click on cell B1 to select it.
Press = to open the Formula editor.
In the editor, enter B1*10
The editor will immediately change the * to a multiplication sign.
Click the green checkmark button to confirm the formula and close the editor.
Cell B1 will display an error triangle.
To use this setup to do what you want:
Double click cell B1 to select it and open the Formula Editor.
Click on the B1 token to select it.
Type the number you want to 'suppose'
Click the green checkmark button to confirm the formula, close the editor, and view the result.
To see the result for a different 'supposed' number:
Double click cell B1 to select it and open the Formula Editor.
Click on the current number (5) to select it.
Type the new number you want to 'suppose'
Click the green checkmark button to confirm the formula, close the editor, and view the result.
You asked to:
This set of steps lets you do that, but it does require that you spoon feed the formula with each new number rather than just placing the number into a cell.
It returns the appropriate result to the same cell as you placed the new number, provided you put that number in place of the previous number, and did not damage any other part of the formula.
It lets you keep 'the same formula' but requires that you change one of the values placed in that formula to make a change in the result.
Personally, I think you'll find it easier (and likely more accurate) to use 'what you don't need' with the entry cell separated from the calculation cell containing the formula.
Regards,
Barry
What do you mean when you say
you 'want to tell what is the supposed value for A1'?
Whom will you 'tell'?
How will you 'tell' that person or thing?
You could put the same formula, referencing a different cell, into C1, then enter the number you 'suppose would be the value in A1' into the cell referenced by the formula in C1.
Here's a possible example:
The formula shown in front of the table is placed in cell C1.
You tell the table the number that is 'supposed' to be (but isn't yet) in cell A1 by entering that 'supposed' number in the highlighted cell, B10.
C1 then shows the result that will be seen in A2 if the value in A1 is the value you entered in B10.
If this example does not fit your situation or what you are asking, please clarify your question.
Regards,
Barry
Hi Barry, Thanks for it, Right but the issue with this method is that if we have 20 numbers we need to repeat the formula every time ( 20 times), I would like to know if there is any way to make it act like coding. keep the formula ( calculator) in a single cell and make things dynamic, means every time that we feed the formula with a number (x), it will return the result of the formula to the certain cell. like this I can keep a single formula as a calculator/generator and each time feed it with number and get the result out of it.
Thanks Barry, I think the best answer is what you mentioned: Number has no "Push"! can only make formulas toward "Pull".
How to suppose a number in Numbers cell?
