IF Function
Solved/Closed
Related:
- IF Function
- Agp function - Guide
- Find function on mac - Guide
- Network card function - Guide
- Function of insert key - Guide
- Accessor function c++ - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 10, 2011 at 09:27 PM
Nov 10, 2011 at 09:27 PM
I wonder whether you can have a formula in a cell to change it own value.
how ever in another empty cell you can have this formula
=IF(COUNTIF(Sheet2!$B:$B,Sheet1!B169)>=1,"Frank DiGiacomo","")
however you can change the value of a cell with a macro . try this macro
how ever in another empty cell you can have this formula
=IF(COUNTIF(Sheet2!$B:$B,Sheet1!B169)>=1,"Frank DiGiacomo","")
however you can change the value of a cell with a macro . try this macro
Sub test()
Dim r1 As Range, r2 As Range, x
With Worksheets("sheet1")
Set r1 = .Range("B169")
x = r1.Value
With Worksheets("sheet2")
Set r2 = .Range("B:B")
If WorksheetFunction.CountIf(r2, x) >= 1 Then
End If
End With
r1 = "Frank DiGiacomo"
End With
End Sub
