Prev: VB codes
Next: Browse to select a folder
From: PRECISION SAILOR PRECISION on 18 May 2010 12:38
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

From: Rick Rothstein on 18 May 2010 12:45
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.)?

--
Rick (MVP - Excel)



"PRECISION SAILOR" <PRECISION SAILOR(a)discussions.microsoft.com> wrote in
message news:6078F3CE-3854-4F88-902B-AF6195E51167(a)microsoft.com...
> 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
>
From: Don Guillett on 18 May 2010 12:46
Your question is not clear to me. As ALWAYS post your code for comments.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"PRECISION SAILOR" <PRECISION SAILOR(a)discussions.microsoft.com> wrote in
message news:6078F3CE-3854-4F88-902B-AF6195E51167(a)microsoft.com...
>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
>

From: Ayo on 18 May 2010 13:23
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)

"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
>
From: Gary''s Student on 18 May 2010 13:24
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

--
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
>
 | 
Pages: 1
Prev: VB codes
Next: Browse to select a folder