If and or nested

[David_UK]

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.

 

[just_jon]

Guessing --

=IF(OR(A4="Won",AND(A4="Placed",OR(A5="Won",A5="Placed"))),SUM(B4:B5),0)

 

[onlyadrafter]

Hello,

RE: adding buttons,

Do you mean you want to add a button on the toolbar?

select VIEW-->TOOLBARS-->CUSTOMIZE

select the COMMANDS tab

Click on any COMMAND ICON (e.g. SAVE), drag this into the toolbar.

Then Right click the mouse on this new button, and you can assign macro, change the image etc.

Is this what you are asking?

 

[David_UK]

Thanks matey, any ideas on how to dock a macro button on the standard toolbar then?

 

[onlyadrafter]

Hello,

What exactly do you mean by a 'macro button'?

What is this macro button for?

 

[Joe4]

You can create a Custom button to put in your toolbar and attach a macro to it. If you put your macro in your personal.xls workbook, then that button/macro will be available whenever you are in Excel. Otherwsie, it will only work if the file containing your macro is open.

 

[David_UK]

Thanks mate, sorted it now...

Cheers all,