In cell M4, you type the formula:

=if(G4="Closed","Closed","")

This will leave M4 blank if G4 is not "Closed", but will make M4 the same as
G4 otherwise.

Or, if you want M4 to be whatever G4 is you simply use:

=G4

HTH,

Eric

"mzwayne" wrote:

Hello! I would like to have a formula that will automatically populate into a
cell. For example:

if G4 says "Closed" then insert "Closed" in M4.

Can anyone tell me if this is possible and how to do it??

Thanks