# Formula for percentage calculation

Closed
XLFaith Posts 2 Registration date Monday March 31, 2014 Status Member Last seen May 1, 2014 - Apr 30, 2014 at 05:37 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - May 1, 2014 at 08:01 AM
Needed a formula in A which will be then pulled down throughout the
column.
Wanted the result in A where B multiplied by C & D and deducting the value in T.
Value in T actually is for percentage. That much percentage should be deducted from the
value obtained after multiplying B C D and put it in A.

I hope it is clear

Thanks

## 3 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Apr 30, 2014 at 04:18 PM
XLFaith, Good evening.

Scenario:
B1 --> 20
C1 --> 5
D1 --> 6
T1 --> 10%

Try to use it:
A1 --> =(B1*C1*D1)*(1-T1)
A1 --> =(20*5*6)*(1-10%)
A1 --> =600*90%
A1 --> =540

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
XLFaith Posts 2 Registration date Monday March 31, 2014 Status Member Last seen May 1, 2014
May 1, 2014 at 12:57 AM
Example if
B is 2
C is 500
D is 2
T is 25 (in T only the number is mentioned and not the % sign)

The answer in A should be 1500

Thanks
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
May 1, 2014 at 08:01 AM
XLFaith, Good morning.