Re: Rounding up the result of an IF function
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
Round the result of your_formula up (away from zero) to the next whole
thousand.
In article <F23182F5-1924-42FE-8E29-A63B5A51B84D@xxxxxxxxxxxxx>,
donnaK <donnaK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
> I have this same issue. Could you write what this translates to in English
> please so I can use/understand the logic behind it?
>
> Thank you
>
> "Frank Kabel" wrote:
>
> > Hi
> > try
> > =CEILING(your_formula,1000)
.
Relevant Pages
- Re: NSE / BR Southern Route Codes
... >displays will force a zero; they can't cope with a blank field ... digits are allowed in the destination field as a way round this? ... Prev by Date: ...
(uk.railway) - Rounding Negative Number Toward Zero
... Is there a way in VB6 to round negative numbers towards zero when the ... to round to 2 decimal places, I would like the number rounded to -0.24. ... Prev by Date: ...
(microsoft.public.vb.general.discussion) - Re: VBA round
... Note that VBA's Round and XL's ROUND treat a 5 in the last significant ... digit differently - XL always rounds away from zero, ... > I am writing VBA. ... Prev by Date: ...
(microsoft.public.excel.misc) - Re: too many zeros and orbital mechanics.
... How do I tell Matlab not to do that? ... I can try round(e) which does round that to zero, ... exact value of zero, clear down to the least significant bit, you can ...
(comp.soft-sys.matlab) - Rounding of integer divisions (was Re: linear interpolation / Assembler / ATMega32)
... The worst thing you may do is to unsignedify the number, round ... The function becomes dead around zero! ... int z, x, y; ... type casts and let the compiler get rid of the extra variables. ...
(comp.arch.embedded) |
|
