need help with formula to make cell a negative value based on values on other cells

[pcorpz]

Hi mvps! I have a quantity column (column M), and have two date columns (return and credit memo, columns S and Z) -- i would like the formula to add a (-) to the qty if either of the date columns have value.

 

[kweaver]

Sub FixM()
Dim LR As Long, i As Integer
LR = Cells(Rows.Count, "M").End(xlUp).Row
For i = 1 To LR
 If IsEmpty(Range("S" & i)) And IsEmpty(Range("Z" & i)) Then
 Else
 Range("M" & i) = Range("M" & i) * -1
 End If
Next i
End Sub

 

[pcorpz]

Sub FixM()
Dim LR As Long, i As Integer
LR = Cells(Rows.Count, "M").End(xlUp).Row
For i = 1 To LR
 If IsEmpty(Range("S" & i)) And IsEmpty(Range("Z" & i)) Then
 Else
 Range("M" & i) = Range("M" & i) * -1
 End If
Next i
End Sub

This worked! Thanks so much!