rounddown

  1. A

    Multiple Condition rounding functions

    Hello, i got a little problem to my rounding function, i got an example Aaron = 120,200 Bella = 120,350 Charlie = 120,670 Dean = 120,880 i wanted to round to Aaron = 120,000 Bella = 120,500 Charlie = 120,500 Dean = 121,000 So far, i got into this mess, working formula, but not intended...
  2. A

    specific round figure

    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...
  3. faeryluv

    IF function with division and FLOOR function

    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...
  4. U

    Combining the sum and rounddown function

    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...
  5. M

    Need help rounding down results of a formula

    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...
  6. G

    Using ROUNDDOWN in pivot table calculated field

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

    Complicated ROUNDUP / ROUNDDOWN issue

    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("...
  8. G

    Append text to indirect reference

    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...
  9. L

    rounding down to nearest whole 5 or 9

    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!
  10. C

    CONVERT DATA with ROUNDUP and ROUNDDOWN functionality using vba

    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_____...
  11. C

    Rounddown to nearest .50

    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...
  12. C

    Y axis on line chart with non fixed data set (number of decimals differs every time)

    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...
  13. D

    RoundDown Function Not Working In My VBA Code

    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()...
  14. M

    Rounddown to calculate qty. Qty dependent on variable units

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top