Login Page - Create Account

Support Board


Date/Time: Wed, 12 Feb 2025 07:12:17 +0000



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

[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