I have a worksheet in which I enter figures as whole intergers. Sometimes I want to increase all numbers by 1.5x, which I know how to do. Is there any way to get the results to read only a whole intergers, such as 3 x 1.5 = 4.5, but I'd like that number rounded to 5 (preferably not 5.0).
View 12 Repliesi have a file that people enter sales figures into each row. the numbers are sometimes beyond 2 demical places.
how would i go about making a macro button, that when pressed, AwardTotal (name of the all the award cells in column e) is rounded to two decimal places. I then would like to sort all the rows that might be inserted, by column "C" (name field).
people will insert rows, with row 11 being the first row with data. Row 10 is hidden, and row 9 is the header row. but the number of rows inserted will be different each time.
I already have a button set up (that someone helped with here of course) that asks how many rows to insert.
I am wondering if there is a way to automatically update my pick 3 lottery files by using excel. I use lottostrategies.com to obtain my results. If anyone knows how I might start to instruct excel to perform such a task, please respond. Or if I am going about this the wrong way in as far as thinking excel can perform such a task.
View 2 Replies View RelatedI want to know how to link te two lists in my register so that when i select a particular route in one column the corresponding column automatically selects the transit time from the reference list.
View 2 Replies View RelatedI am trying to find a way in which a used can enter text into a cell (effectively the search cell) and then that text is compared to text in 3 or so columns, if the text matchs any part of the cells in the those columns then the spreadsheet should filter out the rows that dont have a match and only leave rows that have a match.
Its like having a spreadsheet with a list of part an user can put in 55 or bolt in the cell at the top and the list would only then show all the rows that have 55 or bolt or whatever text in the table below?
I've adapted a spreadsheet to automatically update the latest results.
But my formula (D11), that I got from here, has now stopped working.
I suspect this is due to the formula I've used columns H and I. But I have no solution.
Also the very similar formula used in M15 to M44 has also stopped working, probably for the same reason.
I am a Microsoft Excel 2010 user and am trying to create a usage report for a website that I work on. I have been compiling the usage reports into one spreadsheet. The columns I use are Month, Device, Language, Title 1, and Title 2. I can filter each of these rows and it shows me the number of records found. Each row on this spread sheet refers to a time that someone selected something on the site. For example the row may say;
Month (filtered)
Device (Filtered)
Lan (filtered)
[Code].....
How do I automatically populate a table on a separate sheet with the number of records found for a certain combination of filters applied. So if I'm looking at monthly trending I want to know how many times the stress test was started in May, June, or July, but automatically using info from the multiple filters.
What is a formula I can use to compile the filtered data from above.
Jan
Feb
Mar
Aprl
May
Start
=formula?
Use filter for 2 columns of a CSV file, column A and Column B for certain words. Say I apply a text filter: contains "word1" or contains "word2" to Column A. Then I get the results. After that, I remove the filter to Column A then apply the same filter to Column B. The thing is, I don't get the results in Column B, instead, I get the cells in Column A wherein Column B is filtered PHOTOS BELOW:
The data that I get for this filter are:
And Word1 you
Word2 is blank
Apply filter to Column B, get the cells filtered in Column A:
The data that get for this filter are from Column A (which are cells filtered from Column B filter)
And Word1 you
Is the blah
Word is all
The results should in a single Column for both filter:
I have more than 100 files that needs to filtered this way, is there any way I can do this automatically?
Here is what the file looks like:
The results I hope would be possible:
Automatically without having to open all the files and have the results of all of it in 1 single Excel file?
----or----
If the above is not possible, open each file and automatically apply the filter into a column in just 1 click and without having to type the same filter for each column.
I found a code to combine all CSV files into 1 Excel file, but half of my files has more than 500k rows and the Excel's limit for rows is around 1million+.
I have an excel workbook which requires us to enter the log details of some sites and then a report is generated using these logs (report attached) . [URL] .......
I want that excel should automatically identify the site and calculate its outage with the following formula:
Outage %age= Total Outage(min)/100.80
and add it in the respective column while identifying the outage.
e.g. if outage is of power then the calculated %age outage should be pasted in the power outage column in front of the respected site.
e.g. in the sheet attached above the first row in the first sheet states that SKU2326 was down for 50 mins
Now %age outage will be
Outage %age= 50/100.80
Outage %age=0.496
Now as the outage is related to power so this outage should go into power column in sheet number 3 labelled as "Network Total Up time Week#17"
Now the next time SKU2326 becomes down it should be added with this 50 mins and the outage calculated as presented above.
i m creating a formula that will automatically place players in the correct position based on the outcome and there rank.
I have created an example sheet and the results should be in cells E3:E15
I don't know if there is a setting I'm missing or I'm going mad but when I use the round function in VBA it doesn't round.
I am using Excel 2000. See the example attached.
In the cell A2 I have a value 0.525, cell B2 has a formula "=round(A2,2)" which = 0.53, but cell C2 is assigned via VBA ie
Sheet1.Cells(2, 3).Value = Round(Sheet1.Cells(2, 1).Value, 2)
and the result is 0.52??
I am trying to create formula that will show overtime worked in a given day. The code I am using is a simple one ([ cell - 8], for hours worked). The problem is when the time cells are blank/not used it shows a -8 in the cell. what I need to do to create a code that will eliminate the -8 from showing. The cell its self is taking the result from another cell with a formula and then subtracting 8 from the result of the formula in the other cell.
View 2 Replies View RelatedUsing vba how to round off the value e.g.: The number 582.356894 has to be rounded off to 582.4 ....
View 1 Replies View Relatedi have a list of minutes in cells a1-a5 say 123 256 147 158 235 divided by 60 giving a total of 15.3 hours. i want the hours to round up if over the. 5 mark or round down if under .5 how would i get the desired result?
View 2 Replies View RelatedA cell value is calculated via a formula in vba. I want to round the result down to the nearest odd number or down to the nearest even number, depending on conditions in an other cell. The result is already an integer.
View 8 Replies View RelatedTried the code below to change figures from countless decimal figures to two, however excel is not having any of it,
Range("d:o").Select
Application.WorksheetFunction.RoundDown (2)
Why is Excel not rounding up a percentage of 93.5 to 94?
View 6 Replies View Relatedrounding the numbers. I am working on a quote in which quantity is arrived by dividing the sell price by Total sell price. The condition is the result (quantity) should always be a whole number, I can achieve that by cell formatting but when the calculation is done using handheld calculator the results are different.
I need the result to be same if using excel or handheld device i.e quantity in whole number.
Hi, I have this issue:
1.67 -> DISPLAY 2 ROUNDED
1.67 + 1.67 = DISPLAY 3 ROUNDED
but I would like to know how to sum 1.67 as 2
WANTED -> SUM 2 AS A NUMBER AND NOT A ROUNDED
2+2 = 4
I've been trying various combinations, but currently no joy
I need to work out how long the batten has to be so the roof sheets fit evenly, the measurement has to start from 1460mm and go up in increments of 80mm eg 1540mm, 1620mm, 1700mm and so on.
But the number has be closest increment of 80mm over the shed width if this makes sense, the size of the battens for 2400 width shed would be 2420mm but i need this to work out for any width shed not just 2400.
I am using the rounding function in excel and its rounding to the 10's, is there a way to round to the nearest 5?
View 4 Replies View Relatedi want a cell to round itself. i have a form i'm filling out, based on a percentage of a dollar amount. when the formula calculates, it only shows the first 2 numbers past the dollar point. however, the cell still "knows" what the number is. I have several of these formulas on a spreadsheet, and the sum of them at the bottom of the page is NOT what would you would get adding up the numbers you see on the page, as it is calculating numbers you can't see.
View 5 Replies View RelatedI am trying to do is have the roundup formula round up the result of a more complex formula BUT do it all inside of the same cell? The formula I have is in cell A1 and currently I have to have the cell that contains the round up formula (in cell A2) and have it reference A1. The complex formula is =((280283.47/798186.89)*(700*20*4)) and the result is -19,664.41 which I want to round up to $20,000. Is there a way to make this all occur in just cell A2 or am I stretching it?
View 4 Replies View RelatedI have a number say:
156.9679628 then I go to format to change it to 2 decimal then it would show
156.97 and then I c&p that ... I still get 156.96796284 how do i just get
156.97
I'm creating a spreadsheet to calculate materials with the following columns Cost/10% of Cost/Customer Cost/Qty/Total cost.
I understand that whilst showing rounded to 2 decimal places excel stores more than this in the cell. which then throws out the Total cost by a few pence.
My research leads me to believe I need to use the ROUND function but I'm unsure which cell to use it or how.
round to two numbers. i have this formula
View 3 Replies View RelatedHow do I take a date value and round it off to a fixed month and day of the year following the year entered.
Ex: In cell A1 I have a date: 12/28/2009
I want to round off the date to January 1 of the next year. So I need a function that would return 01/01/2010 (jan 1 2010).
How do I get Excel to round up all values from .3 onwards. EG 2.36 to 3 and 2.29 to 2?
View 4 Replies View Related19.25581
1.01346
3.29376
0.25337
0.25337
1.26683
Total: 25.33660
If I use the Decrease Decimal on the total 25.33660, it becomes 25.34. How do I round all the sub numbers so that 25.34 is achieved.
I have a spread sheet with col's that I want to average their totals, but would like them to be rounded up or down.
View 3 Replies View Related