rounding in excel

I'm attempting to break out a quantity for six locations by a percentage, retaining pack rules with the sum equating to the original quantity. I'm spinning my wheels on a solution and haven't been able to find any help searching around. Is this possible? Would anyone be able to provide...

To seek help on excel formula to auto detect below 3 rules in 1 cell. Please advise. Rules: If decimal in cell more than 0.20 = 0.50; If decimal in cell more than 0.70 = 1; If decimal in cell less than 0.20 = 0. Amount (USD) Wanted Result (USD) 1,074.67 1,074.50 238.84 239.00...

Hi, We have a pricing strategy that we want all rounded to the nearest .95 or .45 if under 500. If over 500 goes to the even dollar. If within 4.00 of a hundred, gets rounded to 99. Examples: 498.00 goes to 499.95 149.00 goes to 148.95 150.25 goes to 150.45 Is there a way to do this, or at...

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

Hi all, I have a worksheet that pulls in data from another source that has 7+ decimal places so when I summarize the data I have balancing issues with the rounding. Does anyone have a macro that will take the data in cells D34:E49, G34:HE49, J34:K49, M34:N49, round and absolute the numbers to...

I can't seem to figure out how to calculate gross margin then round all in the same formula. For Gross Margin I am calculating net price/.7 then I need to round to either 5 or 9. Any help is appreciated then.