$1.00

I have a list of 200 names in column A and a corresponding list of rates in column B. What I need to do is be able to enter one rate and have that rate be entered next to each of the 200 names. So if I enter $1.00, $1.00 appears next to each person's name. Would I use a user form or formula...

To all, I'm looking for a macro that will start in cell D6 and see if the cell contains the word "Custom" anywhere in the cell and if so, highlight the column to the last row with data in it. I then need it to move over to D6 and repeat until it encounters the last column with data with it at...

I am in need of a formula that will allow me to flag if they have a balance within a +-$1.00 range: For instance- Month: Client: Account Balance: August Bob 10.01 August Lucy 11.27 August Sam 9.56 Sept Bob...

I'm looking for a formula that will allow me to multiple one cell by another cell, but if the cell to the right of that one has data then that cell is the one to be multiplied. Here's an example of what I'm hoping to accomplish: A1 - 100 D1 - $1.00 E1 - =A1*D1 However, if cell B1 is populated...

Having trouble determining a formula to return ONLY the cents portion of a column of numbers i.e. 123.50, 234.50 to return $1.00. Possible for both left and right sides of decimal point? J

I WANT TO FIND WHICH NUMBERS ADD UP TO $8452.55 <colgroup><col span="2"></colgroup><tbody> $3,208.20 $1.00 $185.00 $1.00 $30.00 $1.00 $180.00 $1.00 $30.00 $1.00 $194.00 $1.00 $529.74 $1.00 $194.00 $1.00 $194.00 $1.00 $194.00 $1.00 $893.76 $1.00 $201.39 $1.00 $194.00...

Hi All - I currently have a very long and complicated formula that i am positive can be made more simple but just not sure exactly how to accomplish it. I have a table of products, max price, min price, and average as shown below in one tab of an excel <tbody> ColumnA ColumnB ColumnC...

Hello! Any guidance and help will be GREATLY appreciated! I have written out what I need (with examples) to give you a clear picture on what I'm trying to accomplish. I hope it helps. Scenario I have a "revenue forecast" sheet that shows Customer, Item, Quantity and Average Selling Price...