then if

  1. G

    How to Combine Total $ Amount if 2 Values are the same and put into new table

    I have a Table that shows Account Numbers and Date of Payment Most accounts have 2 Payments in the same month. I need a formula that adds the total amount per Account number per month and puts it all into a new Table! For example those 2 rows <tbody> 1701 $200.00 Feb-2013 1701 $30.00...
  2. M

    If then Formula

    I am having an issue with an IF/Then formula in Excel. If cell B has a value greater than 30 then I want the data from cell I2 to be placed in cell A. For example, when 2300487724 is imputed into B2 I want 01/09/2017 to appear in A2.
  3. F

    User Form repeat values based on choices

    Hi, Thanks to all the posts on here I have been able to copy, paste, butcher and fudge my way through to almost what I need. I have a sheet with multiple columns with a list of sites which we may visit to carry out a Test, service, Repair or any combination of the three. <tbody> Site A...

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
Back
Top