<div>
<br />
thanks for immediate reply.<br />
<br />
if there is any sum,avg function instead of value.then what can i do? please explain me ASAP.<br />
<br />
<br />
<br />
THANKS IN ADVANCE<br />
VBDOUBT<br />
<br />
<br />

</div>



thanks for immediate reply.

if there is any sum,avg function instead of value.then what can i do? please explain me ASAP.



THANKS IN ADVANCE
VBDOUBT




<div>
See my question in your other thread, I think that I need to better understand what you are trying to achieve.
</div>


See my question in your other thread, I think that I need to better understand what you are trying to achieve.

<div>
Moderator, my recommended disposition is:<br />
<br />
&nbsp; &nbsp; Accept TimCottee's comment(s) as an answer.<br />
<br />
DanRollins -- EE database cleanup volunteer
</div>


Moderator, my recommended disposition is:

    Accept TimCottee's comment(s) as an answer.

DanRollins -- EE database cleanup volunteer

<div>
Comment from expert accepted as answer<br />
<br />
Computer101<br />
E-E Moderator<br />

</div>


Comment from expert accepted as answer

Computer101
E-E Moderator


<div>
<div class="content wysiwyg-content">
the algorithm looks like this<br />
=IF(P14&gt;=100,1000,500) in excel where p14 represents a cell<br />
<br />
i want this to be interpreted in vb logic within module.<br />
how can it be done?please explain me<br />
&nbsp; &nbsp; &nbsp; whether &nbsp;I have to convert this into vb code consists of if structure.how is it possible<br />
<br />
please explain me asap<br />
<br />
thanks in advance<br />
<br />
vbdoubt
</div>
</div>


the algorithm looks like this
=IF(P14>=100,1000,500) in excel where p14 represents a cell

i want this to be interpreted in vb logic within module.
how can it be done?please explain me
      whether  I have to convert this into vb code consists of if structure.how is it possible

please explain me asap

thanks in advance

vbdoubt

regarding compoent creation

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.