I need assistance creating a formula. The formula needs to be something like this:
. Basically, I need the formula to read the value in cell A and if it is a "1" then the value in Cell G will remain, all other values in cell A will erase the values in cell G. Does anyone know a formula that will do this?
Please Login or Register to view this content.