Hello. First post here. I trying to make a formula that will multiply a cell by 1.43 and then round the total up to the nearest 45 or 95 with no decimal points. Any help would be greatly appreciated.
Announcement
Collapse
No announcement yet.
Round Up To Nearest X`
Collapse
X

Re: Round Up To Nearest 45 Or 95
Datzneat,
Please do not add code tags to formulas. You can if you like add formula tags like this (new feature of website:
[f]=roundup (c2, 2) 5[/f]
gives
Try this formula. Column letter & Row number are for example only. Array formulas will have curly brackets {} emcompassing the ENTIRE formula. You do not add these, you Enter the formula with Ctrl+Shift+Enter and Excel will add them (details: Array formulas). Many more Excel FormulasZ 100 =roundup (c2, 2) 5
Last edited by Reafidy; June 9th, 2007, 11:41.
Comment

Re: Round Up To Nearest 45 Or 95
Originally posted by datzneat11 would be 45
32 would be 45
46 would be 95
1865 would be 1895
11 * 1.43 = 15.73, rounded up to multiple of 45 is 45, to 95 is 95, smaller is 45
32 * 1.43 = 45.76, rounded up to multiple of 45 is 90, to 95 is 95, smaller is 90
46 * 1.43 = 65.78, rounded up to multiple of 45 is 90, to 95 is 95, smaller is 90
1896 * 1.43 = 2711.28, rounded up to multiple of 45 is 2745, to 95 is 2755, smaller is 2745Last edited by shg; June 9th, 2007, 12:18.Entia non sunt multiplicanda sine necessitate.
Comment

Re: Round Up To Nearest 45 Or 95
I don't get what you're saying shg... those were just examples of what i need the numbers to round to, all multiplying aside.
The problem with that code Jim is that it isn't just one code. It is multiple codes, and i'm not sure if rounddown is the best way to do it...
Is there a way to work an OR statement into : =ROUNDUP((C2*1.25),2)5
Comment
Comment