Column Value Until Another Column Triggers Change
We currently have our "BAC" column with this formula , =IFERROR(HTD@row / [% Comp.]@row, 0).
However, we need to be able to change it so that the "BAC" column will equal the "BAE" column until the "HTD" and "% Comp." columns have values entered into them.
Thank you in advance for your help!
Help Article Resources
Check out the Formula Handbook template!