rounddown

I have a question and I hope to get an answer from you. I have grades for some students and I want to make a round figure for the marks in a special way as follows: If the figure in B1 contains 0.1 the round figure should be same 0.1 If the figure in B1 contains 0.2 the round figure should be...

Hi, everyone! I work for a nonprofit and our big Walks are coming up. I am in charge of running reports and getting registration binders ready for volunteers. They will check in Walkers and depending on the amount of money they raised, and the number of members on their team, will hand out...

Hello, I'm having some difficulty trying to use the SUM and ROUNDDOWN function. I have the following formula "=IF(ISTEXT(D3),IF(D3="Basic",SUM(L3:AP3)+COUNTIF(L3:AP3,"NA"),""),"")". This formula looks in column D to see the rate, then sums the entries in cells L:AP. In some cases I need...

I need help adding round down to an existing formula. Any one out there know how to add? I want to perform the following calculation & round down the results in the same cell. For example. . . my formula in B15 is =D13*F13/1095. Right now the result showing in B15 is 58.35342466. I want the...

Hi, I would like to use the ROUNDDOWN function in a calculated field on a pivot table but I am not having much luck nesting the function with the formula of the calculated field. The calculated field formula currently looks like this: = COLUMNX/COLUMNY Column X contains hh:mm:ss data...

Hi All, In my latest Excel 2010 workbook I have the following formula: =IF(L13=0,0,IF(F13="Standard",L13,IF(F13="50%",(LEFT(L13,FIND(" ",L13&" ")-1)/2&" "&RIGHT(L13,LEN(L13)-FIND(" ",L13))),IF(F13="x2",(LEFT(L13,FIND(" ",L13&" ")-1)*2&" "&RIGHT(L13,LEN(L13)-FIND("...

I have done a bit of searching but am having a hard time finding a way to accomplish my objective. I was hoping someone here can help. I have the following query that works perfectly: =IF(INDIRECT(CONCATENATE("'Combined Pipeline...

i have some prices that need rounding down to the nearest whole 5 or 9 e.g. 81.75 - 79 126 - 125 33.75 - 29 Any help would be much appreciated!

I've got a data dump that must be edited/converted prior to pushing it into a different main frame system. There can be NO decimals in the end result. Here's the challenge: ______Col A____Col B___Col C___Col D____Col E Row1__TOT_____1Q_______2Q_____3Q______4Q_____...

Hi Folks, Please can somebody help me with rounding. I am trying to round down after the decimal point to the nearest .5. So in C22 i have the number result of hours worked from time format. C21 shows something like 06:46 hours worked. C22 converts that to number using *24 formula which has...

Hi there, I am trying to build a line chart which is based on a data set which will move over the time. Basically, sometimes my source data will have 4 decimals, sometimes 3, sometimes 2, etc. For example, on a set of data which will have a minimum of 1.3012 and a maximum of 1.4512, I would...

Objective: to let solver do its thing, but after solver runs to have the value in C5 to be rounded down. Example: After solver runs ("C5" = $3,012.63); I need it to display as ("C5" = $3,012). The below code works for with the exception of the my attempt in red: Sub Calc_SingleServDollar()...

Hi Everyone I hope someone can help me with a problem I'm facing. I have a set amount of cash. Say 1000 (A1). I want to calculate how many units I can buy with this 1000. The units trade at a price of 1.5 (B1). However, the issue is that for purchasing these units I will need to pay a...