rounding decimals

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

I have a userform and 2 sheets - sheet2 and sheet6. While entering a quantity in number through userform, data stored on sheet 2 is same as entered. Simultaneously the data is then copied to sheet 6 as current stock. However the sheet 6 shows rounded off number eg. if my input value is...

Hello - I know this sounds strange, but I am looking for a way to condition data in spreadsheet cells to round down at 5 and round up at 6. Example: $2.245 would be $2.24 AND $2.246 would be $2.25. Is this even possible as it seems all of rounding functions in Excel and based on traditional...

Hello everyone, I'm having a difficult time figuring this problem out. I'm trying to round up and down numbers depending on their decimal value. Basically if decimal is equal/over .65, then round up to the next whole number if decimal is between 0.25 and .65 then enter 0.5 and finally if...

Hello, I am in search of a formula that will take the gross number of contracts my company is awarded per month, apply a cancellation rate of 10%, and if the net number is then greater than X.5 awards, round up to the next number. For example, if we are awarded 15 gross contracts in January...

I have a question regarding inserting cell values into a sentence. Lets say I have the following cell values A1= 1,200,000 A2= 34.5267% I have the following formula in a cell ="The value of cell A1 is "&A1&" and the value of A2 is "&A2&" respectively" My issue is when I use this statement I...