Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You have a reply at your other thread.
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
Click to expand...
 
Back
Top