Support Board
Date/Time: Wed, 12 Feb 2025 04:21:47 +0000
[Programming Help] - IF true - copy value from one cell into another
View Count: 522
| [2020-10-02 09:01:40] |
| tommartin321 - Posts: 74 |
|
Hello, I'm working on a spreadsheet system and need some help trying to copy a value from one cell into another cell based on an IF condition. Below is the logic. I have an IF function in P3 and if true, take value in AA3 and copy it into cell Q3. Thank you, Tom |
| [2020-10-02 20:55:50] |
| Sawtooth - Posts: 4173 |
|
Try this in cell Q3: =IF(P3=1,AA3,0) You can also do this: =IF(P3=1,AA3,NOVALUE) Or this, if you want to retain the value until it changes: =IF(P3=1,AA3,Q4) Date Time Of Last Edit: 2020-10-03 13:28:41
|
| [2020-10-03 10:25:58] |
| tommartin321 - Posts: 74 |
|
IF(Condition, TrueValue, FalseValue) So for the "TrueValue", I can just substitute in a cell number to be copied over? Had no idea :) Thanks Tom |
To post a message in this thread, you need to log in with your Sierra Chart account: