round

How can I modify the below to round the output to 2 decimals? =IF(AND(ISERROR(AOT_PricePerShare),AOT_Shares>0),-AOT_BasePrincipal,AOT_PricePerShare*AOT_Shares)

I ran into a little oddity that turned out to be a disagreement between the Round and FormatNumber functions These results are from the Immediate window in a UDF that is interrupted at a breakpoint. The variable Value is defined as double. Its current value is the result of 5-6 calculations...

Hi dears, I would like to know the easiest way to do this in excel and I will really appreciate your help. If the third decimal place is 1 or 2 or 6 or 7 round down to nearest 5. If the third decimal place is 3 or 4 or 8 or 9 round up to nearest 5...

I am looking to roundup if the number in a cell ends higher than 0.2 and round down if its lower than 0.2 so for example 1.2 would round to 2 and 1.1 would round down to 1. Have tried everything with ROUNDUP and IF but can't work it out. Any help much appreciated :-)

I want to enter a formula to round the result ex: =c7/a6 ( I want the result of this rounded to 4 digits) =c4*a2+c4 (I want the result of this rounded to 0 digits) I know this is probably simple but I am having a brain fart...:wink: Thanks

Hi Guys I have this date format as text and would like to convert it to just numbers: This is what I have '3ys 7ms 15ds' and I would like to try and display it as a round number say 3.70 or 3.07 whichever works TIA

Hi All, I am stuck on something very basic....or not... I need to return a value in a cell based on what another cell value is, specifically: A1 contains a Lookup/Array formula which will return either 100,75 or 50 I would like D1 to display 125 if A1 is 100, display 90 if 75 and finally...

Hi everyone, I apologise for the ambiguous title. I am very much a novice at Excel, and am quite unfamiliar with the terminology to use. I belong to a social golf group, and for years we have been manually adjusting our handicaps after each round, so i thought I'd try my hand at automating...

hi guys, im running a tournament and i have alist of names in excel...and as per our rounds we dont like people playing the same person twice, so matchups are made for round 1, then we get our scores in and determine who plays who in the next round...generally the top scoring players will play...

Value = $7,564,264.00 I need this to become a sixteen character text string: 0000000756426400 my formula =Text(Text(substitute(B13,".",""),"0000000000000000" becomes 000000007564264 this works if, for example, the number is $5,469,062.72, but for any round number, it drops the decimal...

Hi, For the most part I am quite proficient in Excel, but there's something I am trying to achieve but don't exactly know how to and what approach to take. I am making a D&D sheet for a games night I have next week and I wanted to have a hidden page that calculate's whose turn it is based on...

hi, bit of background. I'm trying to create a statistics excel sheet for my appallingly bad golf short game. I'm recording the distance to the flag for each putt using my stride length as the standard unit of measurement. anyway I have formula In place that calculate the running total of all...

I have created an excel file which is used to perform a simple calculation. The values will vary depending on the types of category data - there are 12 in total. I have been working my way through to verify the excel calculations of each group using a manual calculator. I have found an issue at...

Hi, i wanted to calculate overtime working hours and would like to include below: 1) round total hours to every 0.25 2) weekday >>>> minus 0.5 hr for =>3hrs and minus 1.0 hra for =>6hrs 3) weekend >>>> minus 0.5 hr for =>6hrs and minus 1.0 hra for =>8hrs issue example : if i use END TIME...

Greetings! I've boldened the portion of my formula in question, below. The columns [Unit Value] and [Mean] primarily contain numbers with 8 decimal places. My First Formula works well - it basically looks for each instant where the data in column Unit Value equals or exceeds the data in...

Hello, conditional format at the moment: =D8>=ROUNDUP($A8,0)/4 I would like to make it percentage but to round to a whole percent down if contains .4 or lower, and round up if contains .5 or more. im guessing something along the lines of =if(D8>=ROUNDUP($A8,0)/100*25....

Currently Matrix table on Report is displaying values in 2 decimal places. How can we round it to 0 decimal place? I look up web resource they ask to use DAX to round but since many rows are 0.2 something, rounding at DAX row level will make them zero but I want to round only at report summary...

I am working on a spreadsheet and I want to round the year for Voluntary Life Product. Basically, I want to take the birthdate and round it to a specific date so that the person doesn't age up until that specific date. For example. If the person is 59 a will turn 60 on their DOB of 5.9.19, but...

Hi, I have the table with a total of 11 cells for 11 quizzes. Example: 1. If all 11 tests were completed on the first attend then I mark as a "P" / overall % completion 100% 2. If 11 tests were failed on the first attend but completed on the second round, I mark as a P-F1 / overall % completion...

HI i currently have the beow code which can add an round formula to an Exiting formula in a cell Sub add_round() Dim rng As Range For Each rng In Selection rng.Value = "=Round(" & Mid(rng.Formula, 2, 9999) & ",2)" Next rng End Sub however i need to undo this -...