close

Hi I am trying to work out a formula for deducting the a certain percentage
of an amount ie:

?204.44 - 11% = ?181.95

A1 A2
204.44 181.95

Thanks

Wiz (but not so in this case)
Hi,

Try place the following formula in A2

=A1-A1*0.11

Seanquot;Wizardquot; gt; wrote in message
. uk...
gt; Hi I am trying to work out a formula for deducting the a certain
gt; percentage of an amount ie:
gt;
gt; ?204.44 - 11% = ?181.95
gt;
gt; A1 A2
gt; 204.44 181.95
gt;
gt; Thanks
gt;
gt; Wiz (but not so in this case)
gt;
In A2:
=A1*(1-11%)

--
Kind regards,

Niek Otten

quot;Wizardquot; gt; wrote in message . uk...
gt; Hi I am trying to work out a formula for deducting the a certain percentage of an amount ie:
gt;
gt; ?204.44 - 11% = ?181.95
gt;
gt; A1 A2
gt; 204.44 181.95
gt;
gt; Thanks
gt;
gt; Wiz (but not so in this case)
gt;

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

    software

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