regarding compoent creation

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
vbdoubtAsked:
Who is Participating?
 
TimCotteeConnect With a Mentor Head of Software ServicesCommented:
Result = Iif(Value>=100,1000,500)

Where Value is the equivalent of the cell's contents.

So if Value = 10 Then Result = 500, if Value = 150 then Result = 1000
0
 
vbdoubtAuthor Commented:

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


0
 
TimCotteeHead of Software ServicesCommented:
See my question in your other thread, I think that I need to better understand what you are trying to achieve.
0
 
DanRollinsCommented:
Moderator, my recommended disposition is:

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

DanRollins -- EE database cleanup volunteer
0
 
Computer101Commented:
Comment from expert accepted as answer

Computer101
E-E Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.