Formula
 

I have a formula that is also calculating empty cells, it becomes a problem
when sorting the result in decending order, because it brings the empty cells
before the results I need. Here is the formula:

With Worksheets("Sheet1")
..Range("Q2:Q" & Cells(.Rows.Count, 8).End(xlUp).Row).FormulaR1C1 = _
"=IF(RC[-5]=0,"""",((RC[-4]/RC[-5])*RC[-9])*100)"
End With

Thank you very much for the help,

Abilio Andries

Formula
 

You have a reply at your other thread.

Abilio wrote:

I have a formula that is also calculating empty cells, it becomes a problem
when sorting the result in decending order, because it brings the empty cells
before the results I need. Here is the formula:

With Worksheets("Sheet1")
.Range("Q2:Q" & Cells(.Rows.Count, 8).End(xlUp).Row).FormulaR1C1 = _
"=IF(RC[-5]=0,"""",((RC[-4]/RC[-5])*RC[-9])*100)"
End With

Thank you very much for the help,

Abilio Andries

--

Dave Peterson