calling a procedure

Hi All

This time my query is with a procedure. At the outset i am still not clear between a function and procedure.
Though i understand Func returns a value but proc doesnt.
fun returns only one value but proc does more than 1 parameter.

Anyways now my question is i am trying to write a procedure at module level.
if value is passed between two numbers the fees for 3 quarters vary. my code is below

Please Login or Register  to view this content.

My Code at sheet level

Please Login or Register  to view this content.

But this doesnt give any result . What corrections to be made please advise.

Something like

Please Login or Register  to view this content.

This will depend upon how you have declared Q1,Q2 and Q3. If this are declared at module or public level, they will be available to subsequent code.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.