USE THE "IF" STATEMENT IN EXCEL
Without VBA:
=IF(G36P36,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
--
Gary''s Student - gsnu201003
"PRECISION SAILOR" wrote:
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
|