(Msg. 1) Posted: Wed Aug 06, 2008 11:32 am
Post subject: Rounding Up Add to elertz Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
Need help with formula to round (always round up) pricing to the next $9.99.
(Msg. 2) Posted: Wed Aug 06, 2008 11:41 am
Post subject: RE: Rounding Up Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
So,
9.99 stays as 9.99 and 10 becomes 19.99. try this
=CEILING(A1+0.01,10)-0.01
Mike
"EFF" wrote:
> Need help with formula to round (always round up) pricing to the next $9.99.
(Msg. 3) Posted: Wed Aug 06, 2008 1:41 pm
Post subject: Re: Rounding Up Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
EFF wrote:
> Need help with formula to round (always round up) pricing to the next $9.99.
=ROUNDUP(A1+0.01,-1)-0.01
This assumes you want $100.00 to round up to $109.99 and not down to $99.99. If
that's wrong, drop the first "0.01".
(Msg. 4) Posted: Wed Aug 06, 2008 7:46 pm
Post subject: Re: Rounding Up Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Try:
=MAX(CEILING(A1,10)-0.01,0)
or:
=IF(OR(A1={0,""}),"",CEILING(A1,10)-0.01)
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
sandymann2.TakeThisOut@mailinator.com
Replace @mailinator.com with @tiscali.co.uk
"EFF" <EFF.TakeThisOut@discussions.microsoft.com> wrote in message
news:6DFBBF50-03DA-43B4-B18A-4FDDE6F5F59E@microsoft.com...
> Need help with formula to round (always round up) pricing to the next
> $9.99.
>
(Msg. 5) Posted: Sun Aug 10, 2008 5:40 pm
Post subject: RE: Rounding Up Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hello
Try =ROUNDUP(A1,-1)-0.01
Regards
farid2001
"EFF" wrote:
> Need help with formula to round (always round up) pricing to the next $9.99.
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office