How can I type 2 effictive formula in one cell?

Hi! I need to type two formula into one cell; such as to displsy in that cell
a percantage of a value of another cell and the result should round up to 2
decimals.
How the new formula should to be typed?

Hi

Something like this:
=ROUNDUP(A1,4)
and format as Percentage with 2 decimals ?

NB! Probably, the ROUNDUP() needs Analysis Toolpack Ad-In to be installed.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )


"Aiman Arafat" <Aiman Arafat@discussions.microsoft.com> wrote in message
news:2F727AF8-3045-4DB0-BA87-3808CD7CD52C@microsoft.com...
> Hi! I need to type two formula into one cell; such as to displsy in that
> cell
> a percantage of a value of another cell and the result should round up to
> 2
> decimals.
> How the new formula should to be typed?
>

Maybe this.......

=A1+B1&" = "&TEXT((A1+B1)/C1,"0.00%")

Vaya con Dios,
Chuck, CABGx3



"Arvi Laanemets" wrote:

> Hi
>
> Something like this:
> =ROUNDUP(A1,4)
> and format as Percentage with 2 decimals ?
>
> NB! Probably, the ROUNDUP() needs Analysis Toolpack Ad-In to be installed.
>
>
> --
> Arvi Laanemets
> ( My real mail address: arvi.laanemets<at>tarkon.ee )
>
>
> "Aiman Arafat" <Aiman Arafat@discussions.microsoft.com> wrote in message
> news:2F727AF8-3045-4DB0-BA87-3808CD7CD52C@microsoft.com...
> > Hi! I need to type two formula into one cell; such as to displsy in that
> > cell
> > a percantage of a value of another cell and the result should round up to
> > 2
> > decimals.
> > How the new formula should to be typed?
> >
>
>
>