Login Page - Create Account

Support Board


Date/Time: Tue, 04 Nov 2025 16:52:31 +0000



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

[2020-10-02 20:55:50]
Sawtooth - Posts: 4285
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