Prev: Macro problem
Next: Macro or VB code to hide and unhide Label box
From: M Thompson on 18 May 2010 18:39
Hi

Please-How do you round up to the nearest $1000.00?

Thanks!
--
OneFineDay
From: Mike H on 18 May 2010 19:06
Hi,

Your question is unclear. Do you mean round up to next 1000?

=CEILING(A1,1000)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"M Thompson" wrote:

> Hi
>
> Please-How do you round up to the nearest $1000.00?
>
> Thanks!
> --
> OneFineDay
From: M Thompson on 18 May 2010 19:13
You read my mind. That worked perfectly. Thanks!
--
OneFineDay


"Mike H" wrote:

> Hi,
>
> Your question is unclear. Do you mean round up to next 1000?
>
> =CEILING(A1,1000)
> --
> Mike
>
> When competing hypotheses are otherwise equal, adopt the hypothesis that
> introduces the fewest assumptions while still sufficiently answering the
> question.
>
>
> "M Thompson" wrote:
>
> > Hi
> >
> > Please-How do you round up to the nearest $1000.00?
> >
> > Thanks!
> > --
> > OneFineDay
 | 
Pages: 1
Prev: Macro problem
Next: Macro or VB code to hide and unhide Label box