What IF

[leoj823]

I need a formula to do the following. When I enter an x in f26 I need the figure in e26 to double.

Let me rephrase the above request. I need a formula to do the following. When I enter a x in f26 thru f47 I need the amounts in e26 thru e47 to double. The example would be e26 has an amount of 9 if a x appears in f26 then the 9 in e26 would double to 18. I hope I'm explaining myself properly. Please also know I have not use macros. So if a macro is the answer I need help with the input.

Leo

 

[VoG]

Try this: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("F26:F47")) Is Nothing Then Exit Sub
If LCase(Target.Value) = "x" Then
    Application.EnableEvents = False
    With Target.Offset(, -1)
        .Value = .Value * 2
    End With
    Application.EnableEvents = True
End If
End Sub

 

[Scott Huish]

Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range, d As Range
Set d = Intersect(Target, Range("F26:F47"))
If d Is Nothing Then Exit Sub
Application.EnableEvents = False
For Each c In d
    If c = "x" Then
        With c.Offset(, -1)
            If IsNumeric(.Value) Then .Value = .Value * 2
        End With
    End If
Next
Application.EnableEvents = True
End Sub

 

[leoj823]

Thank you for your help.

Leo