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;
- Oct 05 Fri 2007 20:40
Deducting a %
close
全站熱搜
留言列表
發表留言