Login Page - Create Account

Support Board


Date/Time: Wed, 02 Jul 2025 05:52:02 +0000



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

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