Support Board

Date/Time: Sun, 22 Mar 2026 08:23:14 +0000

Post From: IF true - copy value from one cell into another

[2020-10-02 20:55:50] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4321
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