Quick one with regards the way I have nested these.
in A4 = Won b4= £20
in A5 = Placed b4=£10
=IF(A4="Won"+OR(A4="Placed"+AND(A5="Won"+OR(A5="Placed"))),B4:B5,0)
Can anyone help. Also while you're at it, does anyone know how to create a button that will be docked in the standard toolbar, what I need is a Macro button, I know how to assign a macro to a normal button, but don't know how to dock it and keep it there like a standard button.
Cheers.
in A4 = Won b4= £20
in A5 = Placed b4=£10
=IF(A4="Won"+OR(A4="Placed"+AND(A5="Won"+OR(A5="Placed"))),B4:B5,0)
Can anyone help. Also while you're at it, does anyone know how to create a button that will be docked in the standard toolbar, what I need is a Macro button, I know how to assign a macro to a normal button, but don't know how to dock it and keep it there like a standard button.
Cheers.