Maybe:
![]()
Sub Sagittariu5() Application.ScreenUpdating = False Sheets("Jul13").Range("A5").Select Do If ActiveCell.Value <> "" And ActiveCell.Offset(0, 9).Value <> "" And ActiveCell.Offset(0, 10).Value <> "" Then ActiveCell.Offset(0, 14).FormulaR1C1 = "= ROUND(RC[-5]*RC[-4]%,2)" ActiveCell.Offset(1, 0).Select End If Loop Until ActiveCell.Value = "" And ActiveCell.Offset(2).Value = "" Application.ScreenUpdating = True End Sub
Bookmarks