decimal

My goal is to calculate the diagonal measurement, in feet and inches, needed to square a building based on depth and width of the building. My formula is A= building depth in ft. and B= building width in ft. So A squared + B squared = C squared Calculate the square root of C squared (ft.) and...

Hi all, I have the following formula and I need to add the ROUNDUP function to it so that it rounds up anything greater than 5 after the decimal point. Where do I add the ROUNDUP function to this formula please. =IFERROR(AVERAGEIF('Data Raw'!$T$4:$T$136,"Commercial",'Data Raw'!$U$4:$U$136),0)...

I have a spreadsheet that I would like people to be able to only enter a time value into. If they enter time as 01:35 this is accepted. If they enter 1.5 it is refused as not in a time format. However if they enter 0.6 it will be accepted and show a time value of 14:24. Surely this decimal value...

Is there a custom format that can be applied to the following? Results like in column B, but I'm needing to apply the custom format on column A. Column A is the result of a formula. AB 115.2815.28 215.0015 312.2312.23 40.020.02 514.0014 60.110.11

Is it possible to have a cell within a spreadsheet that has greater then 30 decimal places?

I am trying to use a cell that is already defined as a percentage and converting it to a decimal instead of adding another column of cells for a vlookup calculation: k2:k21 are defined as xx.x% in column 11. I am trying the following with any result: =IFERROR(VLOOKUP($A$3,'Company...

Hello, I have an Excel file that is pretty simple, 2 cells are link to other tabs and the third one sums the first two. Problem is I want to hide the decimal (whole numbers only), but when I decrease the decimals in the first two columns, the decimal disappears. So for example, if we take cell...

Hi all, I would like to restrict decimal entries in a spreadsheet to be whole or half. For example 5.5, 7.5, 9.5, 22.5 is ok, but 5.1, 7.7, 9.4 ,22.6 etc. is not. Is that possible with formula? The ranges of cells would be D4:D81,F4:F81, I4:I81, L4:L81 Thank you!

Dear Friends, I have attendance machine providing working hours in decimal for my employees. But issue comes when I want to add the attendance from two separate machines for same employee in excel. For Example: Employee 1 1st Machine - 25.45 (25 hrs 45 mins) 2nd Machine - 1.50 (1 Hr 55 mins)...

Hello all, I'm looking for a formula to convert the following: $1,234,567.89 to a text string that looks like the following: 123456789 It needs to en corporate the decimal, assuming the last 2 positions are cents. I'm hoping this is fairly easy and I just haven't had enough coffee yet to...

trying to use the smart complete to create a range of warehouse locations. here is a sample below. with a max of the last decimal of 3. Thanks! <tbody> 011.001.001 011.001.002 011.001.003 011.002.001 011.002.002 011.002.003 011.003.001 </tbody>

Hi there, I am trying to us a SUMIFS to sum a range of numbers based upon a reference. The reference I am using has 12 decimal places (stored as text), i.e.: 120577342.663008205083 When Excel uses the reference it seems to automatically round it up to 6 decimal places i.e...

I am creating a sheet where numbers are raised to negative powers of ten. If I format the cells with the Number Type set to Number and the Decimal Places set to 0 all numbers less than 1 display as 0. I can format each cell individually to display the number of decimal places I want which...

I have a User Form where I ask the user to input a number. This number then gets input into several cells across a few difference sheets. Ultimately the number will be stored in the cells as a percentage, and I have already formatted the cells to hold a percentage with 2 decimal places. So...

Hello Experts, Could you please help me for the below request ? I need to convert all the decimal values into numbers like below, if user type 10.23 it needs to change 1023. I have tried it using Format -> Numbers, unfortunately unable to achieve the desired result. Thanks.

Hi there, This is probably a really basic fix but it from a spreadsheet my boss created so I want to be sure before I mess with it. We are creating an order sheet for garments. First step: We have headcounts per item, we then add a 30% redundancy to calculate the minimum amount to order...

Hi there, when using the Concatenate() command, was wondering how you go about making the distances only show 3 decimal places. EG at current I have CONCATENATE(BEARING,BEARING SYMBOL,MIN,,,SECS,"~10.000000112) Any help would be greatly appreciated, Warmest Regards, Rob

I have a spreadsheet that is calculating a price per square foot of a building. The cell is formatted to Accounting with 2 decimal points. This is what is should be based on my calculator tape 52,000 sf x $61.68 = $3,207,360 This is what the cell multiplication tells me 52,000 x $61.68 =...

Hi, I need assistance with the converting and combining number of years, months and days into a number with decimal places. For example i have known a friend for 32yrs, 6mths and 29 days; how do i convert an combine the duration i have known him for into a number with decimal places...

I have a formula reading: =IF(G29 > 6, 0.5, 0) G29 contains a value of 8.5 (calculated from it's own formula) I would expect the above formula result value to equal .5 It's not; it equals 0 The formatting for G29 is number-format, 2 decimal places. If I adjust the formula to read: =IF(8.5 >...