close

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.laanemetslt;atgt;tarkon.ee )quot;Aiman Arafatquot; lt;Aiman gt; wrote in message
...
gt; Hi! I need to type two formula into one cell; such as to displsy in that
gt; cell
gt; a percantage of a value of another cell and the result should round up to
gt; 2
gt; decimals.
gt; How the new formula should to be typed?
gt;
Maybe this.......

=A1 B1amp;quot; = quot;amp;TEXT((A1 B1)/C1,quot;0.00%quot;)

Vaya con Dios,
Chuck, CABGx3
quot;Arvi Laanemetsquot; wrote:

gt; Hi
gt;
gt; Something like this:
gt; =ROUNDUP(A1,4)
gt; and format as Percentage with 2 decimals ?
gt;
gt; NB! Probably, the ROUNDUP() needs Analysis Toolpack Ad-In to be installed.
gt;
gt;
gt; --
gt; Arvi Laanemets
gt; ( My real mail address: arvi.laanemetslt;atgt;tarkon.ee )
gt;
gt;
gt; quot;Aiman Arafatquot; lt;Aiman gt; wrote in message
gt; ...
gt; gt; Hi! I need to type two formula into one cell; such as to displsy in that
gt; gt; cell
gt; gt; a percantage of a value of another cell and the result should round up to
gt; gt; 2
gt; gt; decimals.
gt; gt; How the new formula should to be typed?
gt; gt;
gt;
gt;
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()