If a cell is less than a specific value

Macro Title:
Worksheet Variable:
Worksheet Name:
Cell Reference of Specific Value:
enter the cell reference that captures the value that you want to test other cells against for being less than this value
Test Cell Reference:
enter the cell that you want to test
Output Cell:
Value if test is True:
enter the value that you want returned if a cell is less than a specified value
Value if test is False:
enter the value that you want returned if a cell is greater than or equal to a specified value
First Comment:

'
Second Comment:

'
Sub If_a_cell_is_less_than_a_specific_value()
'declare a variable
Dim ws As Worksheet
Set ws = Worksheets("Analysis")
'calculate if a cell is less than a specific value
If ws.Range("C8") < ws.Range("C5") Then

ws.Range("D8") = "Yes"

Else

ws.Range("D8") = "No"

End If

End Sub

Sub If_a_cell_is_less_than_a_specific_value()
'declare a variable

Dim ws As Worksheet

Set ws = Worksheets("Analysis")
'calculate if a cell is less than a specific value

If ws.Range("C8") < ws.Range("C5") Then

ws.Range("D8") = "Yes"

Else

ws.Range("D8") = "No"

End If

End Sub

Sub If_a_cell_is_less_than_a_specific_value()
'declare a variable
Dim ws As Worksheet
Set ws = Worksheets("Analysis")
'calculate if a cell is less than a specific value
If ws.Range("C8") < ws.Range("C5") Then

ws.Range("D8") = "Yes"

Else

ws.Range("D8") = "No"

End If

End Sub