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;
- Sep 23 Tue 2008 20:46
How can I type 2 effictive formula in one cell?
close
全站熱搜
留言列表
發表留言