USE THE "IF" STATEMENT IN EXCEL

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
 
R

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

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)
 
G

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
 
Top