USE THE "IF" STATEMENT IN EXCEL

[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

 

[Rick Rothstein]

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.)?

 

[Don Guillett]

Your question is not clear to me. As ALWAYS post your code for comments.

 

[Ayo]

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)

 

[Gary''s Student]

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