If and or nested

David_UK

Active Member
Joined
Mar 18, 2003
Messages
299
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.
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
Guessing --

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

onlyadrafter

Well-known Member
Joined
Aug 19, 2003
Messages
5,703
Platform
  1. Windows
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

Active Member
Joined
Mar 18, 2003
Messages
299
Thanks matey, any ideas on how to dock a macro button on the standard toolbar then?
 

onlyadrafter

Well-known Member
Joined
Aug 19, 2003
Messages
5,703
Platform
  1. Windows

ADVERTISEMENT

Hello,

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

What is this macro button for?
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,913
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,331
Messages
5,595,549
Members
413,996
Latest member
mabelO

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top