Hi, The below formula is suppose to check column A for vaues below 1000 and B for values below 500 an if true want "Yes" retunred otherwise ant "No" returned. I want to adust the formula so that B2 only returns values over 1 as well as those under 500, how can this be done...
2. ### Adjusting table range modifies ROWS formula

Hello, I'm using a ROWS function to list the rows of a table with integers 1 through the rest of the table (Using the method for the "Helper 1" column found at this link: https://trumpexcel.com/extract-data-...rop-down-list/). It generally works fine, but the problem arises when I try adjusting...
3. ### Split Screen different tabs

I have an Excel workbook with one WorkSheet with room numbers and names, then inventory worksheets of computer, printers, projectors...Column A is room number, I have a split screen where column A and title row 1 are split off. If I want to jump from computer inventory to the printer I have to...
4. ### How to adjust date/time for calculation

Hi everbody, This is a tricky one. I want to calculate the duration of a given process. I have the date/time it starts and ends. I achieve this by subtracting one with the other. In the example below, the results are (measured in days): 0,805/0,169/7,056. My problem is that in order to show...
5. ### Asjust price automatically until IRR is hit

Hello, I am building a discounted cash flow model, which calculates my IRR at on a yearly stream of flows. I need a 25% IRR, so I have to manually change the purchase price until it hits. (Goal seek will not work on this model). Is it possible to create a circular reference so the purchase...
6. ### adjusteing numbers in a column

i want a formula or a macro that adjust n and m (m=n-1) digit numbers in a column with adding a zero (0) before m digit numbers. fore example make column2 from column1 in table1. i want this formula or macro do it without selecting cells because i have 250 worksheets and can not do it...

### 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.

### Which adblocker are you using?

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

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