ActiveCell.Formula and IF statement

  • Thread starter Thread starter David
  • Start date Start date
D

David

Hi,

Could I get a hand interpreting this code?? I gather that IF is an
alias for IIf with the syntax: IIf(expr, truepart, falsepart)

ActiveCell.FormulaR1C1 =
"=IF(RC[-1]>=0.04,IF(RC[-1]>=0.05,""Substantial"",""Alert""),IF(RC[1]=""
"",""No"",""Alert""))"

I want to modify this so when the expression evaluates to
"Substantial" the whole row is highlighted too. Any ideas?

Cheers!
 
David,

Essentially:

If ActiveCell(1, 0).Value > 0.05 Then
ActiveCell.EntireRow.Interior.ColorIndex = 3
End If

The "IF" is not an 'Alias' for IIf: your code snippet puts an IF formula
(actually, a nested IF) into the activecell. And the formula doesn't look to
be well constructed, but that wasn't your question....

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Understanding iif statement 7
Cut and Paste using Macro gives paste special method error 2
Excel VBA If statement question 2
prepare a conditional (if) statement 7
C# Convertee - Help with IF statement syntax 5
Dates and Iif function in query criteria 4
Can I put "OR" in a IF(AND statement? 1
Continuation to equivalent for formula - to Mr. Harlan Grove (and notonly...) 1

Back
Top