formula help

Hi I am using =mid to pull data into a table from a worksheet, the data that is pulled across should fall between certain ranges and i was wondering if there was a way to either make the test bold or add a * if it fell out of range. I tried conditional formating but it wouldnt work as the cell...

I have an Excel sheet used for tracking Inventory and I want to be able to monitor all changes in Inventory. I have a column for Quantity Received and another Column Quantity Signed out. I would like for if either Column is Greater than zero to issue a statement in another cell or on another...

I have an Excel sheet used for tracking Inventory and I want to be able to monitor all changes in Inventory. I have a column for Quantity Received and another Column Quantity Signed out. I would like for if either Column is Greater than zero to issue a statement in another cell or on another...

I am trying to forecast orders for a subscription product. I have estimations on the return rate for each period in Sheet1, such as: Return before 1st rebill: 5% Return before 2nd rebill: 7% Return before 3rd rebill: 5% and so on I also have estimations for the % of people that will continue...

First an overview of what I'm attempting to accomplish. I am creating a spreadsheet for my team, and would like to have a drop down in columnm "A" with the names of the team members. Based on the name selected, I would like to have their contact information (phone, fax, email) populate...

I have two lists, both on separate sheets. They both contain ID numbers, but with different data in them. I want to know if there is a way to create a macro that will look up the id number in sheet 1, see if there is a matching one in sheet 2, if there is leave it alone. If there isn't I want it...

I was wondering if you can point me in the right direction. I need to have a macro of formula that would take a cell's value (value1)and spread it over equally over a number (value2) of columns across A B C D E ... 1 $300 3 $100 $100 $100 2 $20 4 $5 $5 $5...

Hello, I'm trying to write a macro or formula that will sum the following =(D2+B3)-C3 on the first day of the month. I need this for each month. Each month will change, so for October 1 2008 I need it to sum =237+B2-C2 November 1 2008 I need it to sum =(D2+B3)-C3 December 1 2008 I need it to...

<HR style="COLOR: #ffffff; BACKGROUND-COLOR: #ffffff" SIZE=1> <!-- / icon and title --><!-- message --> I am trying to link 2 excel Workbooks together and I am wondering if using the SUMIF Function is the best way to do this. I will try to explain and illustrate my position. First I have a...

I need to find a way to speed up the calculations of DSUMs. I have created workbook that has two different tabs with downloaded data from a system query. The DSUMs, based on three criteria, review that downloaded data and show the results. I have 5 tabs full of DSUM formulas. Each tab as...