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.
$A3 is a Pop-Pop Menu:
None
Cantidad
Pagó
I want to clear content of cell values $B3, $C3 and $D3,
if $A3, PopPop selection is None (Blank),
orherwise, I want to input a value on $B3. $C3 and $D3.
Please, tell me that is posible :(
iPhone XS Max, iOS 13
Hi K'
"I want to enter manually values on cells B3, C3 and D3, no matters if I select “Cantidad” or “Pagó” in A3 Pop-Pop selection options."
"But If I select “None (blanks)” in A3, I want to clear or empty B3, C3 and D3 values at the same time."
Can't have both, for reasons stated above, and repeated below.
Back in high school, I discovered there were two core lessons in High School Physics:
F=ma
and
You can't push a string.
The second applies to spreadsheet formulas.
Formulas can not push a value into a cell.
There's no CLEAR() function, nor is one possible. CLEAR as written in your first IF formula is being asked to PUSH a zero or blank value into B3. Not possible.
Similarly, in your second formula, you are asking this formula, located in an unidentified hidden cell, to PUSH a null string into B3. Noy possible that way either.
Any formula that is going to determine the value in B3 must be placed in B3.
Any data entered into B3 by typing it in or pasting it in will replace the formula in that cell.
Moving to a wider view of the picture:
You have three values in your popup menu in A3; none, Cantidad, and Pagó.
Are the values to be placed in these cells available in another cell in this table or another table?
Are they to be calculated from values in another cell (or other cells) in this table or another table?
Are they fixed values, to be written into the formula?
Are they values that you will enter into each of the three cells?
If you are entering the values into these cells, what is the purpose of the pop-up menu cell?
If you are entering values directly into B3, C3 and D3, your simplest course might be to:
Set the pop-up to the required value.
Click on B3 to select it,
Press the shift key and click on D3 to add it and C3 to the selection.
Press Delete to clear all three cells.
Enter the new value(s) in each cell.
Regards,
Barry
Hi K'
"I want to enter manually values on cells B3, C3 and D3, no matters if I select “Cantidad” or “Pagó” in A3 Pop-Pop selection options."
"But If I select “None (blanks)” in A3, I want to clear or empty B3, C3 and D3 values at the same time."
Can't have both, for reasons stated above, and repeated below.
Back in high school, I discovered there were two core lessons in High School Physics:
F=ma
and
You can't push a string.
The second applies to spreadsheet formulas.
Formulas can not push a value into a cell.
There's no CLEAR() function, nor is one possible. CLEAR as written in your first IF formula is being asked to PUSH a zero or blank value into B3. Not possible.
Similarly, in your second formula, you are asking this formula, located in an unidentified hidden cell, to PUSH a null string into B3. Noy possible that way either.
Any formula that is going to determine the value in B3 must be placed in B3.
Any data entered into B3 by typing it in or pasting it in will replace the formula in that cell.
Moving to a wider view of the picture:
You have three values in your popup menu in A3; none, Cantidad, and Pagó.
Are the values to be placed in these cells available in another cell in this table or another table?
Are they to be calculated from values in another cell (or other cells) in this table or another table?
Are they fixed values, to be written into the formula?
Are they values that you will enter into each of the three cells?
If you are entering the values into these cells, what is the purpose of the pop-up menu cell?
If you are entering values directly into B3, C3 and D3, your simplest course might be to:
Set the pop-up to the required value.
Click on B3 to select it,
Press the shift key and click on D3 to add it and C3 to the selection.
Press Delete to clear all three cells.
Enter the new value(s) in each cell.
Regards,
Barry
Hi K'
Whether it is possible depends on what you mean in this line:
"otherwise, I want to input a value on $B3. $C3 and $D3."
The value in C3 (for example) can be the result of a formula in C3, or can be entered directly from the keyboard or pasted from the Clipboard. "clearing' the value in that cell (setting it to zero, or to a null string (blank) can be done using a formula, or can be done by selecting the cell, then pressing delete.
C3 can contain a formula, and display the value calculated by that formula.
OR
C3 can contain an entered value, or can be empty.
C3 CANNOT contain an entered value AND a formula at the same time,
So what you want may be possible, depending what is to happen in B3, C3 and D3 when Cantidad is chosen in A3, and what is to happen when Pagó is chosen.
More details, please.
Regards,
Barry
Thanks for your response.
I want to enter manually values on cells B3, C3 and D3, no matters if I select “Cantidad” or “Pagó” in A3 Pop-Pop selection options.
But If I select “None (blanks)” in A3, I want to clear or empty B3, C3 and D3 values at the same time.
*Thanks to said that is not posible to have a formula and the possibility to enter values in the same cell.*
But are there any other way to clear, assign or move spaces to those cells when I select “None” option in the A3 menu and the ability to enter manually values when I select “Cantidad” or “Pagó” in A3?
I don’t know, maybe an “IF” in another hidden cell like this incorrect formulas:
=(IF $A3=“”, CLEAR($B3))
or
=(IF $A3=“None”, $B3=“”)
Or something like that.
I appreciate your advice.
How to set cell value based on formula in another cell.
