Defining scope of functions.

so when the IF is true, you want total to equal total + ..., and also execute the select portion? If that is the logic then how about:

Please Login or Register  to view this content.

if is true -> total = total +
if is false -> select case & reinitialization of total & increment step

You missed the "else"

(this is part of a small loop)

EDIT:

here is how I would do this in PHP (hopefully will make things clearer)

PHP Code: 

If($cell1 = ""){
    $total = $total + $cell2;
}
else{
    switch($step){
        case 1:
        cell3 = total;
        break;

        case 2:
        cell4 = total;
        break;

        //etc
    }
    total = 0;
    step++;
} 


Please Login or Register  to view this content.

I stepped through this, and it follows the logic. I think the problem with yours is that if what follows "then" is on the same line, it does not see it as a multiple criteria but only does the first IF. In fact I would have thought you'd get an error like End If without If block, or something like that

You're welcome! Please remember to mark the thread as solved?