I have a sheet I am trying to add a formula to a different column if
the value in column 1 is either FAO or FVA. Then I have a subset of
formula to add...if it does not meet this criteria..then it needs to
skip it. It needs to continue to run thru the rows until Col 1 is
blank. The calculation formula works fine...just not at the
appropriate time (hence my request for help)

So in plain language I would like for this to happen

Check column 1 if value = FVA or FAO then

Range("M2").Select
ActiveCell.FormulaR1C1 = "=RC[-7]*0.084"
Range("N2").Select
ActiveCell.FormulaR1C1 = "=SUM(RC[-8]:RC[-1])"
Range("O2").Select
ActiveCell.FormulaR1C1 = "=RC[-10]-RC[-1]"
'Range("M2:O2").Select

If value = anything else then skip
Continue until column 1 = blank

Any help would be greatly appreciated