when i want tu format if else if block i want to get someting like this :
if (1 = 1)
begin
set @avgweight = (select
AVG(Weight)
from Production.Product);
end else if (1 = 1)
begin
set @avgweight = (select
AVG(Weight)
from Production.Product);
end else if (1 = 1)
begin
set @avgweight = (select
AVG(Weight)
from Production.Product);
end

But best what i can do is this stacking indent behavior:

if (1 = 1)
begin
set @avgweight = (select
AVG(Weight)
from Production.Product);
end else

if (1 = 1)
begin
    set @avgweight = (select
        AVG(Weight)
    from Production.Product);
end else

    if (1 = 1)
    begin
        set @avgweight = (select
            AVG(Weight)
        from Production.Product);
    end else

        if (1 = 1)
        begin
            set @avgweight = (select
                AVG(Weight)
            from Production.Product);
        end