<div>
in VBA:<br />
<br />
<br />

<pre><code id="code-30402">If result = 2  and time = 3  then
</code></pre>
</div>


in VBA:




If result = 2  and time = 3  then


<div>
Is that the way it is actually written? &nbsp;So that both conditions must return true on the if part of the statement. &nbsp;Not just one.
</div>


Is that the way it is actually written?  So that both conditions must return true on the if part of the statement.  Not just one.

<div>
yes, the &nbsp;&lt;condition 1&gt; AND &lt;condition 2&gt; will return true only if both conditions return true.
</div>


yes, the  <condition 1> AND <condition 2> will return true only if both conditions return true.

<div>
more compelte verion:<br />
<br />
If result = 2 &nbsp;and time = 3 &nbsp;then<br />
'do action1<br />
else<br />
' do action2<br />
end if
</div>


more compelte verion:

If result = 2  and time = 3  then
'do action1
else
' do action2
end if

<div>
Theres some other ways.<br />
If you just happen to care, while we're point out .net and VBA.<br />
<br />
Excel uses an AND function. &nbsp;IF(AND(result=2,time=3),&quot;W<wbr />as true&quot;,&quot;Was False&quot;)<br />
<br />
In VBA you can implement an AND by nested IFs<br />
<br />
If Result = 2 then<br />
&nbsp; if time = 3 then<br />
&nbsp; &nbsp; 'both were true<br />
&nbsp; end if<br />
end if
</div>


Theres some other ways.
If you just happen to care, while we're point out .net and VBA.

Excel uses an AND function.  IF(AND(result=2,time=3),"Was true","Was False")

In VBA you can implement an AND by nested IFs

If Result = 2 then
  if time = 3 then
    'both were true
  end if
end if

<div>
<div class="content wysiwyg-content">
I'm trying to write an if else statement in which the action would perform if two conditions where true.<br />
example:<br />
If result = 2, and time = 3, then<br />
&nbsp;
</div>
</div>


I'm trying to write an if else statement in which the action would perform if two conditions where true.
example:
If result = 2, and time = 3, then
 

If else statement

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.