| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
USE THE "IF" STATEMENT IN EXCEL
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
USE THE "IF" STATEMENT IN EXCEL
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 wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
USE THE "IF" STATEMENT IN EXCEL
Your question is not clear to me. As ALWAYS post your code for comments.
-- Don Guillett Microsoft MVP Excel SalesAid Software "PRECISION SAILOR" <PRECISION wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
USE THE "IF" STATEMENT IN EXCEL
Not exactly sure what you mean by "+1.0" but this is how you write and IF
statement in excel: =If(G136P32,"+1.0","") If(condition,answer_if_cond_true,answer_if_cond_fa lse) "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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| embedding "ISERROR" function into an "IF" statement | Excel Worksheet Functions | |||
| Call a sub statement in "Personal Macro Workbook" from "ThisWorkbo | Excel Programming | |||
| vba: How do I write a "For Each Statement" nested in a "With Statement"? | Excel Programming | |||
| vba: How do I write a "For Each Statement" nested in a "With Statement"? | Excel Programming | |||
Linear Mode
