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!

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

Formulas can't push but they can pull.

In M4 enter =IF(G4="Closed",G4,"")

If you're looking for VBA solution.

Sub test()
With ActiveSheet
If .Range("G4") = "closed" Then
..Range("M4") = "closed"
End If
End With
End Sub


Gord Dibben MS Excel MVP

On Mon, 26 Jan 2009 14:28:05 -0800, 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!