Strange Round Off Error

Jun 16, 2006

when mixing data types: a real and a complex as in

=IMSUM(-G1/2,IMSQRT(H1))

if G1 and H1 are both exactly equal to 4, the answer whould be 0

see [url]
and look at location I1 (highlighted).

View 9 Replies


ADVERTISEMENT

Remove A Strange Scroll Bar

Feb 27, 2009

I dont know the real name about this scroll bar (like you can see in my attachment), so I cant search in the forum, sigh! how can I remove the bar in the red circle?

View 3 Replies View Related

Strange INDEX Phenomena?

Oct 8, 2009

INDEX(Sheet1!$F$2:$F$10,0,1) returns #VALUE!
INDEX(Sheet1!$F$2:$F$100,0,1) returns 110 (e.g.)
As Both index have zero(0) for its row reference (row_num) I would expect both formulas to return #VALUE! (or even #REF!)

View 2 Replies View Related

Strange Characters Appears

Sep 16, 2009

there is a strange character that appears in an excel spreadsheet. It looks like a square with a question mark in it.

what this means and am I able to remove them

View 9 Replies View Related

Strange Characters Equal EOF

May 28, 2006

I made a userform that spits out 'logs' in a more readable easy to understand. It basically shoves everything into a nicely organized list box.

I have a load button that if pressed accepts .csv's

It works perferctly for practically every type of .csv that contains these logs however 1/100 times the logs contain korean or chinese characters which cause the program to crash.

I gone through some debugging and I found out that the characters that cause it to crash happen to equal the EOF character. So not only does it spit an error on that line, it stops loading anything after that point.

Here is my CheckFileSize function that runs first to tell me how long I should make my list.

Private Function CheckFileSize(ByVal TempFileName) As Double
Dim TempData As String
Dim SizeCount As Double

how to do this besides loading it into a worksheet first?

View 9 Replies View Related

Strange Thing Only On One Computer Running This XLS

Feb 4, 2009

Copy of the scaled down Workbook are enclosed. Password is "j". Sheet("Final Schedule") is one of 11 sheets in the Workbook. Range("a10: BE120") is copied from another Sheet and pasted.

ISSUE BACKGROUND: Entries into cells are Data Validation and a drop down on each cell. In cells C15, 16, 17, 18 or O15, 16, 17, 18 First time the Sheet is opened: user has no problem if they select a D from the drop down.

ISSUE:
But if user types in D and hits enter key, contents of G10: M10 (merged cells) is copied into that cell. Any thoughts on where to check or what settings to check? It only happens on that one computer.

View 3 Replies View Related

Today Function Works Strange

Aug 24, 2009

I have a column, where i want to calculate the difference between today and another date/or viceversa. The problem is, that in the first two cells, it calculates it well, but then, it shows #VALUE and when I press to see the "calculations steps" , it shows "29/09/2009"-40049. It turns the today function into a number. Why?

View 11 Replies View Related

Referencing To CSV File In Strange Format

Oct 21, 2009

I am working on an excel dashboard to display life information about energy consumption.

there is currently a bespoke syatem which does this but we need the dashboard to be changed so the job has fallen to me.

Energy usage across the site is recorded in a spreadsheet (automatically) every half an hour and is saved in a folder named CSV data, however the files are saved in a format which i assume is something for the current package: *.ew7

I can open and view the data by clicking "open as" and selecting excel.

I can reference to this data from another excel spreadsheet (dashboard) whilst they are both open it will update.

However when i close all spreadsheets and open just the dashboard it tells me that the links cannot be updated.

I need a solution or a way around this so i can reference from one workbook to another.

Has anyone had any experience of this kind of thing? can anyone offer a humble analyst a bit of advice?

I was not able to attach the file here (as its in the ew7 format) but i have uploaded it to rapidshare for anyone who wants to take a look...

View 14 Replies View Related

Strange Characters Pasting To Textbox

Dec 20, 2006

it is a very simple marco. It contains a textbox input within a user form. The only problem I have is, when I use CRTL-V to paste some text into the textbox, it has a wired character attached to the end of the text.

for example, I highlighted an email address (ex. abc@abc.com) from an email, use CRTL-C to copy, and I make sure that there is no space after the .com, and after I pasted using CRTL-V to the textbox, a wired character, like a reversed P sign..... very much like the carriage return in MS Word, would anyone know how to avoid that or disable that extra character?

View 3 Replies View Related

Increase In Decimals Returns Strange Result

Jul 21, 2006

I have discovered a strange thing about excel and it is driving me mad and ruining my project.

Basically, If i enter the number 97.4 into cell A1 and then 97.165 into cell B1 and then enter the formula =A1-B1 into cell C1 i get the answer 0.235. Which is correct.

However, when you increase the number of decimal places to 30 the answer that is returned is 0.234999999999999000000000000000.

This calculation result seem to fluctuate wildly depending on the primary numbers in cells a1 and b1. Very rarely have i seen the full 30 decimal places without a bizarre result like this.

Maybe it has been too many years since i was at school and that i am confused with my numbers and that there is a real easy answer to why this result is returned.

As i said it is ruining my project that i am working on. Can anyone help? Why does excel do this? Is there a way to stop this happening? My project relies on this answer to be correct. Is there a way to force excel to stop doing this?

View 9 Replies View Related

To Rid Fields Of Strange Social Security Numbers

Mar 16, 2007

weeding out a huge file I have of 10,000 users. When the usernames and social security numbers were entered originally, there were many mistakes on the social numbers, some were longer than 9 numbers and some were shorter....well now I need to delete the rows of the numbers that are nonsense, so I need help in finding or creating a script that goes thru my XLS file and strips out all the rows with less than 9 or more than 9 characters....can someone direct me on how to do this? here is an example of what im talking about

484818227 | John | Doe |
283298383 | Bob | Smith |
2039022221 | James | Dean | <--------need this row removed
293938832 | Billy | Bob |
29832E | George | Bush | <--------need this row removed as well

View 3 Replies View Related

Bulk Convert Strange File Format In Multiple Folders.

Oct 27, 2009

I have a series of files in *.ew7 format (i know its a random program)

I have some code which i can run which will simply open the relevant file and save it as xls.

The files are saved in multiple folders in format "yymm" eg: 0910 - oct 09.

inside each folder there is a ew7 file for each day in rthe format: "01ddmmyy" eg 01271009 = 27th oct 2009.

I have folders going back as far as may 2002 (in folder 0205) and i need a way to convert these all into xls format and save them in the same location.

View 13 Replies View Related

Macro Worked For 2 Years, Suddenly Started Giving Strange Results

Jan 20, 2009

I have a VBA macro that I pieced together* a couple of years ago to help with a pretty simple task. We have two excel sheets that pull in information daily from different sources. The macro copies and paste values for the worksheet, then 1) saves a copy of the values only worksheet with the current date, 2) resaves the values only worksheet as a .csv file that is then manually uploaded into our database.

View 3 Replies View Related

VBA Round Function Vs Worksheet Round Function

Oct 24, 2006

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??

View 9 Replies View Related

How To Round Of Value In VBA

Sep 28, 2012

Using 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 Related

Round Up/round Down

May 12, 2009

i 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 Related

Round To Odd /even In Vba

Nov 6, 2009

A 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 Related

Round Down

Jan 7, 2010

Tried 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)

View 9 Replies View Related

How To Round Up A Percentage

May 5, 2014

Why is Excel not rounding up a percentage of 93.5 to 94?

View 6 Replies View Related

Round To Whole Number?

Feb 3, 2014

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

View 5 Replies View Related

Sum Literally :: Round Off

Dec 11, 2008

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

View 10 Replies View Related

Round Up In Units Of 80!

Jan 11, 2009

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.

View 3 Replies View Related

Round To The Nearest 5

Feb 20, 2009

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 Related

Cell To Round Itself..

Aug 5, 2009

i 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 Related

Round Up Formula

Sep 24, 2009

I 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 Related

Round The Numbers

Oct 7, 2009

I 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

View 2 Replies View Related

Use IF And ROUND In Same Calculation

Oct 23, 2009

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.

View 2 Replies View Related

Round To Two Numbers

Jan 26, 2010

round to two numbers. i have this formula

View 3 Replies View Related

Round Off A Date

Jan 27, 2010

How 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).

View 5 Replies View Related

Round Up All Values

Feb 11, 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 Related







Copyrights 2005-15 www.BigResource.com, All rights reserved