Hello, I would like to know how to retain a value in a formula for a row of cells (as a result of a query) while being able to replace it if a test is met . Any help would be greatly appreciated.