Floating Binary In Subtraction

Oct 13, 2008

cell A1 contains the numeric value: 3961.3
cell A2 contains the follwing: ="z equals "&B3-3933.7

which i would expect to give me: "z equals 27.6"

BUT, it gives me: "z equals 27.600000004"

which is awefully strange becos the 4 comes form nowhere...

what makes some sort of sense is that if the value in A1 is changed to 3961.4 or 3961.5, then the final decimal 4 in A2 changes into a 3, and then a 2.

when the value in A1 is changed to xxxx.7 the number in cell A2 becomes what one would expect it to be.

how do i get rid of these strange decimals???

(formatting cells, setting number of significant figures does not work. i naturally already tried that)

View 8 Replies

Decimal To Binary?

Oct 27, 2007

Does anyone know how to convert a 4 digit number to binary in excel? I used the =DEC2BIN formula, but it only works on a 3 digit number that is smaller than 512.

View 9 Replies View Related

Export To Binary Format

Sep 5, 2009

Is there anyway to convert excel sheet into a file with binary format?

Or maybe export them into binary files?

I want to change my database type to binary from text..

Problem is my database is Huge, it's a 1044x1044 matrix..

The previous .txt database is exported using macro, into 1044 files that contain 1044 values each. I want to do the same except with binary format...

View 7 Replies View Related

Compare The Binary Sequences

Nov 18, 2008

I have 70 sequences of binary coded variables each, which I would like to compare in terms of overlaps for the number "1", e.g.,

a1 1 0 0 0 0 1
a2 0 1 1 1 0 0
a3 0 1 1 0 1 0
.
.
.
a70 0 1 0 0 0 0

How can I do a pairwise comparison in Excel for the number "1" (ie how often does the number "1" occur at the same place for two sequences?).

I thought about a correlation matrix (that compares sequences a1-> a2, a1-> a3, a1->a4, ...., a1-> a70; a2->a3, a2-> a4, ...., a2-> a70; .....; a69-> a70), but am looking for an easy way to compute this in Excel.

View 6 Replies View Related

Reading Binary File Bug

Jun 16, 2006

I am running into one of the strangest issues I have seen in a long time. I have a user defined type that I utilize in VB6 and write out to a binary file....

View 7 Replies View Related

Convert Decimal To 13 Bit Binary

Aug 11, 2008

I was reading this Binary Conversion from Decimal on this site, however i am unable to reply to the thread. This code is exactly what i was looking for but have the need for it to be able to give the result as a number of bits eg. i would like the result to be dispalyed as 13 bits. I have tried modifying the code without any success and would like to be able to use it in this form. Public Function Dec2Base( Num As Long, base As Long, length as long) As String

View 3 Replies View Related

Subtraction Without Borrow

Nov 2, 2008

Is thee any formula to deduct the higher value from a lower value without carrying. for example:

A1 = 01234
A2 = 56789

A3= should be = 55555

is there any formula like this

View 14 Replies View Related

Floating Textbox

Nov 1, 2008

I have a textbox that constantly shows the contents of cell B1, a changing cell, as it is a total formula (to make my textbox display the contents of cell B1 I clicked on the textbox and then entered =B1 in the formula bar).

Trouble is, my textbox scrolls with the rest of my sheet and soon disappears from the screen. I need it to float on the screen and remain always visible when the sheet scrolls far up or down. How can I achieve that?

Or is there any other floating object that will constantly display the changing contents of cell B1? I�ve tried a textbox within a UserForm (which does float and remains always visible) but I cannot make that textbox display the contents of B1.

View 9 Replies View Related

Floating Link....

Apr 7, 2009

I wish to have a floating link in large spreadsheets that will always be visible and when clicked will return to a particular cell in that same spreadsheet.

View 2 Replies View Related

Floating Message Box

Jul 8, 2009

Is there any code available for a floating Message Box instead of Standard Message where by the user can scroll the sheet and decide to choose "Yes" or "No".

View 4 Replies View Related

Create A Floating Tab?

Feb 23, 2012

if it is possible to create a floating Tab like you get on websites, so ehwn you move the spreadsheet to the left or right, the tab/shape with words in moves with you.

View 8 Replies View Related

Conditional Subtraction

Jan 9, 2008

Im using the following formula

=IF(E5"",NETWORKDAYS(E5,IF(F5="",TODAY(),F5),Holidays),"")

to calculate training shifts spent in my training centre. We have 2 sets of occupational groups, those of underground & those of surface. I need to subtract 1 shift from the formula but only for the underground guys.

View 9 Replies View Related

Floating Table

Jun 12, 2008

I was asked by a co worker if there is a way to make a data table float b/w tabs or in other words, it would always be visible no matter what tab or location you are in a workbook.

My first answer was no, that he would need to create that table on each tab and freeze the panes so that it was visible no matter where he was in his workbook.

View 9 Replies View Related

Subtraction Formula

Oct 21, 2009

I have data that when added together will have decimals of .1 or .2. Any decimal great than .2 becomes an integre of 1 and is added to the other integres. for example: 1.1, 2.0, 3.2, 5.1=12.1.

I now want to subtract this total from another amount that will give me values with decimals of .1 or .2, example: 59-12.1=46.2 not 46.8. The same if 62-8.1=53.2.

View 9 Replies View Related

Sum Function But For Subtraction

Jul 27, 2006

Is there a " Sum" function that can be used for a cumulative series of subtractions?

For example, if I have 10, 12 and 15 in 3 respective cells, and use the sum function upon them, it will return 37.

However, I want to say 10 minus 12 minus 15, and thus return -17.

View 3 Replies View Related

Excel 2007 :: Convert Hex To Binary?

Feb 7, 2012

I want to convert Hex to Binary. I want the Binary in 8 different cells.The hex input would be lets say A1 I would want to convert that to eight different cells Bit7 G10, Bit6 G12, Bit5 G14, Bit4 G16, Bit3 E10, Bit2 E12, Bit1 E14 and Bit0 E16.

Then I want another Hex input on A2 and convert that to eight diferent cells.

Bit7 K10, Bit6 K12, Bit5 K14, Bit4 K16, Bit3 I10, Bit2 I12, Bit1 I14 and Bit0 I16.

How would I do This?

View 9 Replies View Related

How To Speed Up Binary File Read

Apr 9, 2014

I have written a little test sub which reads the contents of a binary file, which is approximately 0.2 Mb in size, into a byte array.

My sub is as follows:

[Code]...

It works just fine, BUT, it is incredibly slow (it spends 80 seconds in the For loop!!!!!)

How can I speed this up?

Note that the binary file can be of arbitrary size.

I tried using a string buffer filled with zeros, and it works!

View 1 Replies View Related

Working With Data In Binary Format?

Jun 15, 2009

How well does Excel / VBA deal with data in a binary format? I am working on a Base64 decoder, which in basic terms means I will have 4 numbers, which I need to convert into their binary representations (6 bits each). I then need to combine these binary groups together, and then divide them up differently to give me 3 numbers (made of 8 bits each).I'm just wondering if anyone has any examples on how best to work with binary in Excel? Also if there are an gems of builtin library functions?

View 4 Replies View Related

Formula For Binary To Decimial Not Working Right

Mar 11, 2009

this formula was working great since 12-08, but someone came to me yesterday saying there is a flaw in the formula between Company A and Company B

If you note that 10.125.239.0/24 is overlapped with 10.125.236.0/22, yet is marked FALSE ...

View 9 Replies View Related

Large Hexadecimal To Binary Function

Jun 9, 2007

I read the thread Converting from Hexadecimal to Binary and what I need to do is convert the following hex number to binary; 9E6799CF. The function in that thread doesn't seem to handle that large of a hex value. Is there anyway of doing that with a HexToBin function, short of chopping it up converting the smaller numbers and recombining it in binary?

View 2 Replies View Related

Formula For Minute Subtraction?

Mar 6, 2014

What is the formula for taking two times, and finding the minutes between them. E.g. 12:35 PM-12:28 PM=7. I know i can use (A1-A2)*1440, but is there an easier way?

View 4 Replies View Related

Floating First Column In A Spreadsheet

Nov 24, 2008

I am trying to get the first column to float down as you scroll down the spreadsheet to fill in information. How do I get that going. I can't figure it out.

I use excel 08, computers viewing the files are 03.

View 2 Replies View Related

Time Subtraction Formula

Nov 28, 2013

I'm trying to do the following:

In the attached file, I'd like to subtract whichever is the earliest time between B4 or C4 from A4, then B5 or C5 from A5, etc.

I assume I need a conditional "if" statement but I'm not sure if that will work.

Attached File : Time Subtraction Example.xls‎

View 7 Replies View Related

Subtraction Based On Next Cell Value

Jun 19, 2014

I would like if active row cell "AF" has the words "Visa Signature, the same active row "AP" value, 25 should be subtracted from it.

View 3 Replies View Related

Subtraction Macro Request

Jul 12, 2007

I have Time Data in one column, and Values in the next, and then a blank column (for calculations, like subtraction/time).

Is there any way to automate the =Cell2-Cell1 command for regions of blue cells and have it paste the value in the blank column lined up with the first blue cell of the region?

The attachment will make more sense, but this is what I'm talking about:

Before subtraction macro:

BlueTime1 Value Blank BlueTime4 Value Blank
BlueTime2 Value Blank BlueTime5 Value Blank
BlueTime3 Value Blank BlueTime6 Value Blank
Blank Blank Blank Blank Blank Blank
BlueTime7 Value Blank BlueTime10 Value Blank
BlueTime8 Value Blank BlueTime11 Value Blank
BlueTime9 Value Blank BlueTime12 Value Blank

After subtraction macro:

BlueTime1 Value BlueTime3-BT1 BlueTime4 Value BlueTime6-BT4
BlueTime2 Value Blank BlueTime5 Value Blank
BlueTime3 Value Blank BlueTime6 Value Blank
Blank Blank Blank Blank Blank Blank
BlueTime7 Value BlueTime9-BT7 BlueTime10 Value BlueTime12-BT10
BlueTime8 Value Blank BlueTime11 Value Blank
BlueTime9 Value Blank BlueTime12 Value Blank

View 11 Replies View Related

Floating Navigation Window

Sep 9, 2009

I want to create a floating window in excel that can contain a series of macro buttons (12 total)

I'd like to see if this window can be opened with a hyperlink or a single macro button on a spread sheet.

View 11 Replies View Related

UDF For Floating Point Conversion Of 32 Bit Hex

Sep 18, 2009

See here:
http://www6.uniovi.es/~antonio/uned/...-754hex32.html

This site allows me to enter a 32-bit Hexadecimal Representation and get Decimal Floating-Point result.

For instance, 4224A012 gives me 41.2.

Is there a UDF available to do this inside of Excel?

View 3 Replies View Related

Addition And Subtraction Using IF Formula

May 1, 2013

Lets say I have a #2 in cell A1 and #4 in cell B1 and would like an output in C1 as "plus 2".

Right now I have =if(a1>b1,b1-a1,???) what can I put in the [value_if_false] to return "plus 2" or do I have to use another formula?

View 1 Replies View Related

IF Statement With Date Subtraction

Jul 9, 2007

I am trying to use a IF statement to extract date data by months.

e.g. : =IF(I13134="A",H13134(Date field) - (date by 3 months)

I hope that makes sense:

So I guess if the field I13134 has the letter "A" in it - Look at field H13134 and subtract that date by 3 months.