USE THE "IF" STATEMENT IN EXCEL

  • Thread starter Thread starter PRECISION SAILOR
  • Start date Start date
P

PRECISION SAILOR

I would like to use an IF statement to program events on an EXCEL spread sheet.
For example, "IF G136 > P32 THEN +1.0". Can this be done???
THANKS! RAFAEL DE ECHEANDIA, HAMPTON, VA
 
We are talking about VB code, not worksheet formulas, correct? Can you
provide more detail as to what your example is supposed to be doing (what
kind of events, add 1 to what, etc.)?
 
Not exactly sure what you mean by "+1.0" but this is how you write and IF
statement in excel:
=If(G136>P32,"+1.0","")
If(condition,answer_if_cond_true,answer_if_cond_false)
 
Without VBA:
=IF(G36>P36,1,0)
with VBA:
Sub demo()
Set p36 = Range("P36")
Set g36 = Range("G36")
If p36.Value > g36.Value Then
ActiveCell.Value = 1
End If
End Sub
 
Back
Top