help with a text formula

[mzwayne]

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!

 

[egun]

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

 

[Gord Dibben]

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