dollar

Hello friends, Im trying to figure out a best way to get data based on todays date. Here is the situation: First Tab I have todays date: =today()...TAB 1 CELL A1 Tab 2: I have 3 COLUMNS Column A: DATE -which has the first of month date(e,g. 03/01/2018, 04/01/2018, 05/01,2018....etc) Column B...

Hi, We have a pricing strategy that we want all rounded to the nearest .95 or .45 if under 500. If over 500 goes to the even dollar. If within 4.00 of a hundred, gets rounded to 99. Examples: 498.00 goes to 499.95 149.00 goes to 148.95 150.25 goes to 150.45 Is there a way to do this, or at...

Having trouble writing an IF, AND, AND, OR Equation. Wishing to based on what the dollar amount in column D and the desired choice for a percentage, I believe I came close but no cigar. Spreadsheet is available. The AND should be if cell D is greater than zero, then do X, Y, Z, based on the...

Hello. I have a spreadsheet that contains multiple documents some of which are duplicates. The vast majority of the time the duplicates have different dollar amounts. However, after applying an INDEX/MATCH, the formula returns the fist dollar value it reads and applies that amount to all...

Hi All, I`m looking trying to code my script for Excel, I have a Data set that looks like this <tbody> Country City Dollar Notes Hello Country City Dollar Country City Dollar Notes Hello </tbody> What I want to do is go through all my data. If I find something...

I have product codes in column A, prices in column B, and Names in Column C. I Am looking for help with a formula or a macro to do the following: Delete duplicate rows in column A but keeping the lowest dollar value B. Also if the lowest dollar values are duplicates then I would need a...

I have been able to work with these with some success. What I am having trouble with is getting the formula to use more than one column to choose the data from. formula =sumifs(tkcol,tkno,dola,dolb,dolc) where tkcol is the truck range, tkno is the truck to match, and the last 3 will have...

How to use Goal Seek to change the period of the loan to limit dollar amount?

Hi All, I have a workbook that has two worksheets on it. One sheet has 1982 locations that have 3 rows each (consecutive) on the sheet. The third row of each location has three possible entries - it could be a blank cell, it could have the text value Y, or it could have the text value D...

I have this formula, =quotient(A1,(counting(A2:A6,"*")) that I am using to split a tip dollar amount. My problem is that it seems to just return an answer that is rounded to the dollar even though I have it going out 2 decimal places. I need it to stop rounding. Please help.

I have a huge excel spreadsheet that I have inherited through an acquisition. 32,000 rows with 10 columns. I would like to count some dollar amounts in column "K" based on a vendor name in column "F and a division name listed in column "E". For example if I wanted to know how much money, from...

Hello everyone There are two things I'd love to be able to do in Excel in order to save me a lot of time - 1) When entering formulas, is there a keyboard shortcuts that, when selecting an array, includes the $ signs to fix the array? 2) When creating Pivots, is there a way to select the...

I've got a macro which copies data from one sheet in one workbook into another sheet in the same workbook based on certain criteria with formatting changes applied: Sheets("Sheet1").Select Range("J" & CStr(LSearchRow)).Select Selection.Copy...

Is there a way to create some kind of output into multiple cells? For instance, I have a dollar amount that I want to increase by 5% each year but I don't know how many years yet. But based on user input (say 10yrs) 10 cells would be created, each 5% larger than the next?

Hello all, I am creating an inventory sheet and am stuck on the waste category. It is obviously easier to count the waste as whole units, but I would like to assign dollar amounts to each unit in each cell, individually. For instance, for hamburger buns($.33) lost, arbitrarily I would put 40...